Re: problem loading data

From: Brett Geer <brett@brabys.co.za> > >use HPL? > >You might want to try this, we did and it worked nicely on 7.31 > >1) Create raw table How'd you create a raw table in 7.31? >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 >----------------------------------------------------------------- _____________________________________________________________________________________ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com

In article <90ql4j$kfp$1@news.xmission.com>, "Obnoxio The Clown" <obnoxio@hotmail.com> wrote: > > From: Brett Geer <brett@brabys.co.za> > > > >use HPL? > > > >You might want to try this, we did and it worked nicely on 7.31 > > > >1) Create raw table > > How'd you create a raw table in 7.31? 7.31 supported raw tables. Documentation Notes for Administrator's Guide for Informix Dynamic Server 7.31.UC1 -- K. Nonlogging Tables for Dynamic Server 7.31 You can create logging or nonlogging tables within a logging database on Dynamic Server, Version 7.31. The two table types are STANDARD (logging tables) and RAW (nonlogging tables). The default standard table is like a table created in earlier versions without specifying a special keyword. You can create either a standard or raw table, and alter tables from one type to another. -- Will Sent via Deja.com http://www.deja.com/ Before you buy.