RE: SE on HP-UX: Loading Large Table

Actually, I've seen this happen if you have transaction logging on a database. For reasons I'm not going into, the longer a transaction gets, the slower it gets. HPL will definitely be faster, but if you don't have it, dbload -n 10000 ...rest of stuff... will definitely help. >From: "Schaeflein, Paul" <pschaefl@Sidley.com> > >I would use the HP Loader (needs X-Windows) or the dbload command. > >-----Original Message----- >From: rajsingh@hotmail.com [mailto:rajsingh@hotmail.com] >Sent: Wednesday, March 17, 1999 8:16 AM >To: informix-list@iiug.org >Subject: SE on HP-UX: Loading Large Table > > >We're running SE on HP-UX 9.04. We're trying to load a large table (125 >Mbs) >from an unload file. There are no indexes on the (destination) table. It >seems >as the table gets larger (as more and more rows are inserted), the process >becomes slower and slower (i. e. LOAD FROM "textfile" INSERT INTO table). > >Does anyone know how to speed this up and why it's so slow? >-- >Mr. Rajendra Singh, B. Sc. (rajsingh@hotmail.com) >"What is understood need not be discussed." - Loren Adams > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com