MySQL Forums
Forum List  »  Optimizer & Parser

Re: Queries using JOIN and ORDER BY LIMIT
Posted by: Nikita Dubrovsky
Date: March 14, 2012 08:45AM

Thank you for the replies. I've read about using "bookmarks" instead of offset for pagination, but for now I'm just restricting the ability to page beyond the first few pages. The problem is that the query has the same performance issue for the first page ("limit 20" with no offset).

So if I understand correctly, the only way to improve the query performance is to have the filtering and sorting columns in the same table and create a combined index for them?

Is there anything else that can be done to improve the query time? Are there any new features in MySQL 5.5 or later that would help with this kind of query?

Nikita

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Queries using JOIN and ORDER BY LIMIT
1560
March 14, 2012 08:45AM


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.