scrolling db-query results

[Anon]

Does anybody here know where I can find a code which scrolls around 1,000,000 non-mySql-database-query results displaying around 10 results every page. Or, if you have any opinion on how may I code this scenario, please let me know.
My main problem here is that my query returns so many results that it would be very difficult for the end-users to view all of the results.
My other problems are database and speed.
I'm using oracle as my database, therefore I won't be able to use mysql's limit offset.
And around 1,000,000 results would definitely affect the speed of the application.

[techek]

Right off of my head, it sounds you'll have to code the logic to handle which records to show ...

If OFFSET is the number in where to start and RECORDS is the number of records you want to display, have a look at this :

Idea 1 : Read your records OFFSET times. From there continue to read your records RECORDS time and print each row.

Idea 2 : Select records from your DB where the key is between OFFSET and OFFSET+RECORDS. This would be quite silly if you have gaps in your keys (eg. 1 2 3 5 7 8 9 and so on)

Idea 3 : Use a DB that does indeed support limited selection. Mysql?

[amcgrath]

Try SLEECT * from table limit $limit,$offset

where $limit is the max amount of records to display, and $offset is the record where you want to start.

[techek]

I'm not sure if you read eloy's question properly, but he / she writes : "I'm using oracle as my database, therefore I won't be able to use mysql's limit offset." But maybe you do have another suggestion on how to solve the problem ...

[amcgrath]

Ha, I guess i didn't. Well, it's been awhile since I last used Oracle, but couldn't he use ROWNUM in some fashion? (Grasping here, I know).