Re: Informix and MS Access

stuff cut out... >My problem is in trying to insert 12,000 records located in an >Access table into the an Informix table. The insert query starts >off just fune until it gets to about 50% or 60% percent complete. > At that point, everything starts to slow down --- Windows seems >to begin to swap to the hard drive, network traffic just about >stops, and Access seems to only be inserting 5 to 10 records per >minute. I let the job run for over 12 hours and it never will >finish --- my PC finally hangs. >It seems that Windows starts running out of memory and starts >swapping way too much --- it shouldn't --- the PC is a 486/66 >with 16 MB of RAM. >Any suggestions? If possible try and load the file in smaller batches, this may help... It does sound as though you have come up against a limitation there... gordonh@acslink.net.au RIPLEY, Queensland, Australia