Re: Queries using JOIN and ORDER BY LIMIT

[Nikita Dubrovsky]

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