MySQL Forums
Forum List  »  Performance

Re: Long execution time despite LIMIT 3
Posted by: Joachim Berger
Date: June 21, 2011 07:28AM

Hi Rick,

thanks. Everything you say sounds valid. To your points:

- Yes, about 5880 was the number in that case.

- Your pattern

( SELECT ... ORDER BY ... LIMIT 3 )
UNION
( SELECT ... ORDER BY ... LIMIT 3 )
ORDER BY ... LIMIT 3

is the one I'm working on right now.

- "sufficiently scattered", "cache were cold", "..same query again, it would run much faster" --> everything correct.

I'll try to benchmark the above pattern now.

Regards,
Ben

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Long execution time despite LIMIT 3
855
June 21, 2011 07:28AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.