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

Home -> Community -> Usenet -> c.d.o.server -> Incremental returns from a large query: Server Caching

Incremental returns from a large query: Server Caching

From: <vlee_at_jps.net>
Date: Fri, 15 Oct 1999 00:00:53 GMT
Message-ID: <7u5qre$g34$1@nnrp1.deja.com>


I have a table with 4618 records. Our application is written with ASP and does not handle sessions id's very well. Currently each time a user asks for more data, we select all 4618 records. Our proposed solution is to have the data server cache the records and as we need the data poll it (i/e. 10 records per page (prev10 /next 10 -> Give me the next 10 to 4618 records). Can this be done? Can I store the records in some area of memory and get the records as I need them?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 14 1999 - 19:00:53 CDT

Original text of this message

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