Oracle DBI Perl Showing a part of a record set.

I'm trying to find a good solution to this problem and was hoping to get some suggestions.

I have a CGI program that queries and prints our the records from a table. If the record set is say 100 records and I only want to show say 20 at a time (so page loads fast,) and give the user the option to then view 20 more, how do I do this?

I know I could query the table each time the program was called and just show the requested records, but that seems inefficient sense I am still queering and retrieving the entire record set (and think if it is like 1 million records, ouch.)

One restriction, I don't have write permission one the web server so I can not create any temp file to dump the data into and then read back from either.

Any ideas?
Thanks

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Mar 31 2000 - 12:35:35 CST