Re: problem loading data

Posted in 2000

Obnoxio The Clown — Fri, 08 Dec 2000 12:15:36 -0000 — source: Informix-list mailing list archive (1991-1998)

From: "Duck" <duck@network.com> > >I would like to know how to reduce the length of my checkpoint. Actually I >am loading a 13M records (with laod command) into a table with 2 indexes. >It tooks about 20 to 30 seconds to my checkpoint to complete while the >loading process. > >Is there any solution to reduce this time to something acceptable like 5 >seconds for example. Run checkpoints more often? Clearly, you need to see what a checkpoint does to understand why your checkpoints get so long. It may be less time overall to have one long checkpoint than many short ones... _____________________________________________________________________________________ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com