Re: Slow inserts

Posted in 2005

Ben Thompson — Fri, 26 Aug 2005 09:46:55 +0100 — source: Usenet: comp.databases.informix

Hi Art, > Ben, do you perform large numbers of deletes on this table? The > periodic large numbers of IOs on the table's chunk may be BTREE > cleaner/scanner activity. BTW Version and platform info would be > helpful, especially since the BTREE cleaning functionality has changed 3 > or 4 times over recent releases to improve things. We're using 9.40.UC5 on Linux IA32. We don't delete from this table except at off-peak times where there is a special process that handles this. This process is not running when the go-slows occur. Is there an "onstat" command I can run to monitor the BTREE/cleaner/scanner activity when this occurs? Ben.