MySQL Forums
Forum List  »  Optimizer & Parser

Re: how to optimise query for 10+ millions records
Posted by: irek kordirko
Date: February 09, 2012 05:31AM

Azhar Rahi Wrote:
-------------------------------------------------------
> Well its quite possible that user want to see all
> destinations.So what I have have done to fulfil
> this, is to apply a condition with ifnull
> statement in where clause:

Do you really belive that the user wants to see 10 million rows on the screen, even divided by 100 records per page (100.000 pages) ?
Ask him if he really wants to click 100 thousands times on "next page" button to see all of these rows.



Edited 1 time(s). Last edit at 02/09/2012 05:32AM by irek kordirko.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: how to optimise query for 10+ millions records
1444
February 09, 2012 05:31AM


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.