Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Oracle DBI Perl Showing a part of a record set.

Oracle DBI Perl Showing a part of a record set.

From: <beastdvd_at_my-deja.com>
Date: Fri, 31 Mar 2000 18:35:35 GMT
Message-ID: <8c2r5l$8s8$1@nnrp1.deja.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US