Re: how to optimise query for 10+ millions records
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.
Subject
Views
Written By
Posted
3411
February 09, 2012 03:30AM
Re: how to optimise query for 10+ millions records
1889
February 09, 2012 05:31AM
1582
February 09, 2012 05:38AM
1458
February 09, 2012 05:58PM
1432
February 11, 2012 11:26PM
1711
February 12, 2012 10:12PM
1557
February 13, 2012 02:18PM
1756
February 14, 2012 02:33AM
1572
February 14, 2012 07:24AM
1574
February 15, 2012 07:30AM
2075
February 16, 2012 03:54AM
1467
February 17, 2012 01:20AM
1440
February 17, 2012 03:57PM
1708
February 17, 2012 05:12PM
1543
February 18, 2012 07:18AM
1548
February 21, 2012 03:25AM
1587
February 24, 2012 10:45AM
1533
February 20, 2012 02:21AM
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.