Art S. Kagel said:
> 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.

This assumes that you only badly index one table. In *my* experience:

a) often the badly indexed table is a central table in the system,
accessed very often;
b) if you have one badly indexed table, you have a dozen.

I'll stick with indexing, thanks! ;o)

--

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