MySQL :: Re: mysql order by limit too slow, faster when making select a sub query

Contact MySQL |
Login | Register

The world's most popular open source database

Documentation Downloads MySQL.com

Developer Zone

Section Menu:

New Topic

Re: mysql order by limit too slow, faster when making select a sub query

Posted by: Øystein Grøvlen
Date: March 20, 2013 05:39AM

In order to say something about this, I would need to see the output of EXPLAIN for these two queries.

Øystein Grøvlen,
Senior Principal Software Engineer,
MySQL Group, Oracle,
Trondheim, Norway

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Views

Written By

Posted

mysql order by limit too slow, faster when making select a sub query

2523

Mathew V

March 20, 2013 01:54AM

Re: mysql order by limit too slow, faster when making select a sub query

1116

Øystein Grøvlen

March 20, 2013 05:39AM

Re: mysql order by limit too slow, faster when making select a sub query

1046

Rick James

March 20, 2013 09:07AM

Re: mysql order by limit too slow, faster when making select a sub query

6730

Mathew V

March 20, 2013 10:37PM

Re: mysql order by limit too slow, faster when making select a sub query

1734

Rick James

March 21, 2013 09:16AM

Re: mysql order by limit too slow, faster when making select a sub query

1538

Øystein Grøvlen

March 22, 2013 04:03AM

Re: mysql order by limit too slow, faster when making select a sub query

1365

Rick James

March 23, 2013 12:17AM

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.