Subject Re: Why it's soo slow ? it's just a very simple select ...
Author nathanelrick
> You've presented the list with a problem that we haven't been able to solve
> given the information available. And no, "the index entries are NOT spawn
> in the record page" - index entries use only the key values, they're stored
> on index pages, and they're prefix compressed. I haven't a clue what
> problem you're seeing. Did gstat tell that your indexes are more than
> three levels deep?

thanks to the list, by deeper investigating i now see that the probleme is in the "prepare" step ... but still not understand why, and if it's a bad engine conception (or a bug) and most important how to avoid it ...

>Paying for support isn't cheap, but wasting weeks of
> your time trying to resolve a problem isn't free either.

I agree, what will be good is to have something like a "hotline" support service ... if someone have some offer i will be happy to receive it