browsing sorted resultsets from an oracle db
| From: | Markus Mirsberger | Date: | Mon, 13 Jan 2003 15:57:42 +0000 |
| Subject: | browsing sorted resultsets from an oracle db | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-24807@lists.php.net to get a copy of this message | ||
Hi,
I got the following ( simple :) ) problem. I have like 1 million keys and I
want to browse through them ....like"show next 10" or "show last 10" or
"show next" or "show last" for example. this is pretty easy in mysql but for
some reason not in oracle:)
The first solution I had is to have a subselect where I select all data,
number it and select the data I want to show from this subselect. But every
single site takes ages to load and its not very intelligent to get all data
first, number it and then just select like 100 rows from that subselect :)
I think many people have/had this problem but I didnt find anything while
searching the web.