Re: Informix Performance Issues

#1 (**permalink**) 04-20-2008, 09:00 AM

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?

--

Bye now,
Obnoxio

"C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule"
- Coluche

"I'm trying to see things your way, but I can't get my head up my ass"
- JCH

"Ogni uomo mi guarda come se fossi una testa di cazzo"
- Marco

Travel broadens a person. You look as if you have been all over the world.

I went to the airport to check in and they asked what I did because I
looked like a terrorist. I said I was a comedian. They said, "Say
something funny then." I told them I had just graduated from flying
school.

-- Ahmed Ahmed

http://i2.photobucket.com/albums/y41...theproblem.jpg
sending to informix-list

#2 (**permalink**) 04-20-2008, 09:00 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode