Re: Slow checkpoints

Posted in 1998

Gerard Crockenberg — Wed, 28 Jan 1998 15:00:54 -0500 — source: Informix-list mailing list archive (1991-1998)

Try : select count(*) total, 0 percent from bigtable into temp mytemp with no log; update mytemp set percent = total*.75 where 1=1; select * from mytemp; Gerard Crockenberg President Crockenberg Consulting, LLC gerardc@bellatlantic.com Normand Bedard wrote in message <34C88F4A.867DB3A@bellsygma.com>... >Hi, > I run a query on Informix On-Line 7.23UC2 and I go from >1 sec. checkpoints to 30 sec. checkpoints. Any explanations? >The table is partitioned and it is very large (46 million rows) >Any explanations? Can I avoid this situation? > >select count(*) total,count(*)*.75 percent >from fact where telz[5,12] = '555-1212'> >-- >Normand B'dard >Consultant - Bell Sygma >671 De La Gaucheti're, B300 >Montr'al, Qu'bec H3B-2M8 >mailto:normand.bedard@bellsygma.com >Tel:(514)870-0957 Fax:(514)391-6360