Re: INFORMIX AND MS ACCESS

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. : > 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