SE on HP-UX: Loading Large Table

Posted in 1999

Rajendra Singh — Wed, 17 Mar 1999 14:15:42 GMT — source: Informix-list mailing list archive (1991-1998)

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