Re: Incremental returns from a large query: Server Caching

From: Gert De Neve <Gert.DeNeve_at_advalvas.be>
Date: Fri, 15 Oct 1999 20:27:04 +0200
Message-ID: <7u7t7k$h2m$2@news0.skynet.be>

Seems to me like an "in memory database".

Expand the Shared Pool so all data can fit in memory. The first time you select the data, it will be loaded in the data buffers. The next time you select the data you can read it from memory.

Hope this helps
Gert
<vlee_at_jps.net> wrote in message news:7u5qre$g34$1_at_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 Fri Oct 15 1999 - 13:27:04 CDT