MySQL Forums
Forum List  »  Optimizer & Parser

Estimating query results quantity
Posted by: Andrey M
Date: December 18, 2007 08:25AM

I have a huge table that is displayed using pagination and certain queries, that is the total results pages/items quantity depends on the queries and always is different. These queries work too slow and maybe anyone can advise a way to optimize this process maybe by making an estimation of the results number. E.g. I saw Google just shows Results 11 - 20 of about 40,100,000 How do they do it?

Options: ReplyQuote


Subject
Views
Written By
Posted
Estimating query results quantity
3113
December 18, 2007 08:25AM


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.