Re: bad performance on delete

Cristoff wrote: > On Informix 7.23, when deleting records on large tables it goes very > slow. What should we change to get better performance? > > $ onstat -p> > INFORMIX-OnLine Version 7.22.UC2 -- On-Line -- Up 01:06:01 -- 130680 > Kbytes You're on 7.22, not 7.23, and you should not be on it still. 7.24 was the Y2K-compliant version of IDS 7.2x. There's no guarantee that simply changing the software would alter the performance of anything, you should still be feeling a little uncomfortable about using quite such an archaic version. OTC gave some moderately good advice - at least, look at your indexing strategies. Are you using fragmentation appropriately; do you have enough disk drives? -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.01 -- http://dbi.perl.org/