statuscount.cgi performance (WAS Re: Custom fields schema)

[Joel Peshkin]

Kevin Benton wrote:

>Yes, however, MySQL (in 3.x) apparently won't use more than one index per
>table.  Since there's an awful lot of data to go through to get to the point
>where I can extract the necessary information, I just don't see how FAR will
>work at this point without being able to sub-index.  Again, I'm glad to be
>proven wrong.
>
>  
>

We have a general consensus that sites with an interest in DB 
Performance should be on MySQL 4.something.  Does the same concern apply 
there?