[Spam] Re: [bbDev] [688] trunk: indices for date columns.

[Michael D Adams]

On Feb 11, 2007, at 10:39 AM, Matt Mullenweg wrote:

> m at wordpress.org wrote:
>> +  KEY forum_id (forum_id),
>> +  KEY topic_time (topic_time)
>> +  KEY topic_start_time (topic_start_time)
>
> I'm skeptical of this.
>
> MySQL can only use one index per table per query, so if any  
> combination of those fields are used in queries for a true speed-up  
> we should use a multi-field key. (Like we do in WP.)

We should probably be doing a multiple column key on forum_id and  
topic_time (or the other way around).

The only place we really query by topic_start_time in when we're on  
profile pages.  Perhaps a muli column key with topic_start_time and  
topic_poster.

Michael