Re: Informix Performance Issues

Posted in 2005

Art S. Kagel — Thu, 31 Mar 2005 17:55:15 -0500 — source: Usenet: comp.databases.informix

TBP wrote: > Art S. Kagel wrote: > >> TheBigPotatoe wrote: >> >>> "Art S. Kagel" <kagel@bloomberg.net> wrote in message ... >>> <snip> <more scissor work> > > I sort of completely agree with you, and I sort of don't. BUT without > knowing more about what this geezer is doing (and the user base), I > think it a bit "extreme" to state 128 / 32 is completely wrong. OK. > Also, OTC does have a valid point about bad indexes - missing indexes > will cause buffer flooding as well, which affects everyone :O. Definitely. But I normally ignore OTC, why change now? > Allright, 32 / 4 is nice :) - depends on 4k or 2k platform, and also > what is read from disk in one go - ooops :O Ya. > Can you flame potatoes? Probably :) I LOVE roasted potatoes! Art S. Kagel