Re: Slow checkpoints
In article <34D0E9C3.440D1C41@bellsygma.com>, Normand Bedard
<normand.bedard@bellsygma.com> writes
>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.
>
Because the select is doing lots of disk i/o. Hence the disk i/o
for the checkpoint has to wait..
>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
>
--
David Williams
Maintainer of the Informix FAQ
Primary site (Beta Version) http://www.smooth1.demon.co.uk
Official site http://www.iiug.org/techinfo/faq/faq_top.html
I see you standin', Standin' on your own, It's such a lonely place for you, For
you to be If you need a shoulder, Or if you need a friend, I'll be here
standing, Until the bitter end...
So don't chastise me Or think I, I mean you harm...
All I ever wanted Was for you To know that I care