RE: problem loading data

During Loads you actually want long checkpoints the disk write is more efficient - unless that is you actually have users on the system at the same time. Same is true of index builds. Last 7.3 box I worked on I had different onconfigs for loading, index building, updating and letting users actually onto the system. As each different scenario cropped up, we would reboot to that onconfig. cheers j. > -----Original Message----- > From: Duck [mailto:duck@network.com] > Sent: Thursday, December 07, 2000 11:26 PM > To: informix-list@iiug.org > Subject: problem loading data > > > 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. > > please reply + cc:donald.leclerc@domtar.com > > Donald Leclerc > dl@novertech.com > donald.leclerc@domtar.com > > >