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

[Max Kanat-Alexander]

On Mon, 2005-01-31 at 07:54, 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.

	It'll work pretty easily. You just have to create the right
multi-column indexes. Thankfully, with just one table, that's not a
problem.

	-Max