RE: SE on HP-UX: Loading Large Table

Posted in 1999

Schaeflein, Paul — Wed, 17 Mar 1999 09:56:14 -0600 — source: Informix-list mailing list archive (1991-1998)

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