Re: MAX and GROUP problem. Help!

[Felix Geerinckx]

359359 wrote:

> I've did this:
> SELECT test.*
> FROM test
> LEFT JOIN test AS s2 ON test.ELEMENT=s2.ELEMENT AND test.VALUE<s2.VALUE
> WHERE s2.ELEMENT IS NULL
>
> ...and it is working file but when I run on the bigger DB (50.000 rows) it take's me 35 min. Is
> there any fastes way?

Please post the result of the following command:

EXPLAIN SELECT (rest of your query) \G

(don't forget the \G instead of the usual ; - the formatting is these forums is sometimes horrible)

--
felix
Please use BBCode to format your messages in this forum.