Re: problem loading data

use HPL? You might want to try this, we did and it worked nicely on 7.31 1) Create raw table 2) Load 3) Alter table to standard 4) Make indexes The only problem is that there is no log on the raw table so then if you have to restore prior to your next backup the table aint there. It is backed up and logged after the change to standard brett Donald Leclerc wrote: > > 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 -- ----------------------------------------------------------------- Brett's 10th law of UNIX administration... rm is forever ----------------------------------------------------------------- Brett Geer - UNIX Admin/Analyst/Programmer - Intratex Holdings. Tel. +27 31 717 4000 Direct. +27 31 717 4146 Fax. +27 31 717 4001 ----------------------------------------------------------------- The little voices are talking to me again, telling me to reach for a keyboard and type rm -rf /* last week they had me rm -rf `echo $MANPATH | sed 's/:/ /g'` now I fear I have no answers -----------------------------------------------------------------