Re: Informix Performance Issues

Obnoxio The Chav wrote: > Art S. Kagel said: > >>Let me say this for everyone and for all time. Excessive readahead is the >>single most pervasive cause of poor performance and requiring excessive >>caching than any other cause. Perhaps than all other causes combined! > > > Bad indexing strategy? Bad indexing strategies affect a single table and do not rob performance from other users, so the effect is limited. The affect of bad RA is global. I'd like to take this opportunity to apologize to TBP if I seemed to have been flaming you on this issue (and perhaps I was). I get worked up about stuff, but I normally keep it contained. <head hanging down> I'm sorry. Art S. Kagel