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

Max Kanat-Alexander mkanat at
Tue Feb 1 01:04:35 UTC 2005

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


More information about the developers mailing list