Re: Group-wise Maximum performance

[Felix Geerinckx]

Jon Richards wrote:
> Ok here's the result of describe table:
>
> 'name', 'varchar(255)', '', 'PRI', '', ''
> 'time', 'bigint(20)', '', 'PRI', '0', ''
> 'type', 'int(11)', '', 'PRI', '0', ''
> 'data', 'text', 'YES', '', '', ''

As noted in another post in this thread, it would be interesting to check wheter your query uses the multiple primary key for all columns (I have my doubts) - check this with EXPLAIN.

If not, try to create an index on the time column:

ALTER TABLE foo ADD INDEX (time);

--
felix