Slow checkpoints

Posted in 1998

Normand Bedard — Fri, 23 Jan 1998 07:38:34 -0500 — source: Informix-list mailing list archive (1991-1998)

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