MySQL Forums :: Performance :: Long execution time despite LIMIT 3


Advanced Search

Re: Long execution time despite LIMIT 3
Posted by: Joachim Berger ()
Date: June 21, 2011 02:06AM

It somehow seems I might be getting there:


I could rewrite the SELECT as follows:

(SELECT m.*, m.flags + 0 flags
FROM messages_test m
WHERE (m.thread = 817549.001266066) AND (id_user_s = 817549) AND (del_s = 0))

UNION

(SELECT m.*, m.flags + 0 flags
FROM messages_test m
WHERE (m.thread = 817549.001266066) AND (id_user_r = 817549) AND (del_r = 0))

order by id desc
LIMIT 3;


and have indexes like:
test1 (thread,id_user_r,del_r)
test2 (thread,id_user_s,del_s)


What do you think?

Options: ReplyQuote


Subject Views Written By Posted
Long execution time despite LIMIT 3 1634 Joachim Berger 06/19/2011 12:47PM
Re: Long execution time despite LIMIT 3 672 Joachim Berger 06/19/2011 12:54PM
Re: Long execution time despite LIMIT 3 631 Rick James 06/20/2011 06:33PM
Re: Long execution time despite LIMIT 3 649 Joachim Berger 06/20/2011 11:44PM
Re: Long execution time despite LIMIT 3 696 Joachim Berger 06/21/2011 02:06AM
Re: Long execution time despite LIMIT 3 692 Rick James 06/21/2011 07:23AM
Re: Long execution time despite LIMIT 3 593 Joachim Berger 06/21/2011 07:28AM
Re: Long execution time despite LIMIT 3 685 Joachim Berger 06/21/2011 10:33AM
Re: Long execution time despite LIMIT 3 744 Rick James 06/21/2011 10:08PM
Re: Long execution time despite LIMIT 3 926 Joachim Berger 06/22/2011 12:33AM
Re: Long execution time despite LIMIT 3 635 Rick James 06/22/2011 07:26PM
Re: Long execution time despite LIMIT 3 649 Joachim Berger 06/22/2011 11:45PM
Re: Long execution time despite LIMIT 3 624 Rick James 06/23/2011 08:53AM
Re: Long execution time despite LIMIT 3 714 Joachim Berger 06/24/2011 02:51AM


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.