Re: loading large *.unl file into database with logging

Posted in 1999

Mark D. Stock — Mon, 13 Sep 1999 21:06:35 +0100 — source: Informix-list mailing list archive (1991-1998)

"Art S. Kagel" wrote: > > All of the suggestions are fine but missed an obvious solution. Here is > mine: > > 1) If you have 7.31+ create the new table with a temporary name (like > origtable_new) as a TYPE RAW table. Well the blonde dude did, but what about HPL? That will bypass everything (logging, buffers, etc.) for the quickest load. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock http://www.informix.com |//////// /| | mailto:mdstock@mydas.freeserve.co.uk |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |What year 2000 bug? year 2000 bug? |/// / ////| | |year 2000 bug? year 2000 bug? year |// / /////| | |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+