Performance hit with large...

> > A client of ours has standard Informix 5.02 installed as part of a turn-key > > system from a third party, and is experiencing a bad performance hit > > on a table with a compound index, which has grown to over 30,000 rows. > > > > They have heard a rumour that this is a known problem. Can anyone shed any > > light? > > --------------------------------------------------------- > > Chris Palmer > > Deloitte Touche Tohmatsu, Auckland, New Zealand > > c.palmer@dtt.co.nz > Can you give us some more on the configuration/schema ?? It would be useful to know how the data is being accessed, is it being sorted ?? The fact that you mention a compound index may indicate that some kind of sort is being performed..out in /tmp for instance !! After all 30,000 rows is not necessarilly big and Informix can certainly be tuned and optimised in many ways. But, as ever (and applicable to many postings), to start on a solution we need to know more about the problem. Best Regards Tom Hogarty Standard Disclaimers Apply SNI Paderborn Germany Tel +494-52518-11602 +494-5254-65553($HOME) mail <bumidev.pad@sni.de>