Re: Slow checkpoints
Thank you for the responses,
I know how to solve the problem but I would like to know
why the checkpoint go from 1 sec. to 30 sec. when doing a select.
Gerard Crockenberg wrote:
>
> 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
--
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