Re: INFORMIX AND MS ACCESS

Caelus (caelus@comtch.iea.com) wrote: : Brian Green (brian.green@sltrib.com) wrote: : : > 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. I had a client that was having a similar problem although he was going in the opposite direction. His query would eventually hang his pc and never finish. I believe he set the Access query mode to 'passthru' and everything worked fine. : : > 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? : : Have you tried breaking it up into smaller chunks? Try breaking the query : : into smaller pieces and doing the inserts that way. I ran across something : : similar with Powerbuilder a couple of years ago, when I tried to create a : : dbase file with a large select. It ground to a halt after several hours : : when I tried to do the whole thing in one select, but when I broke it into : : 4 queries, it took less than an hour total. : : --- : : ~ SPEED 1.40 [NR] ~ : Sounds like what is happening is that there's a meory leak somewhere and : as a result windows begins paging to disk until it finally runs out : (don't ya just love windows!). If that is the case would breaking it up : help without restarting windows between the pieces? Curious to hear what : you find out. : Regards, : Larry Jones