Re: Polling and caching? Is this possible?

From: B.Ludwig <ludwig.spamno_at_bit.nl>
Date: Sat, 16 Oct 1999 20:01:16 +0200
Message-ID: <3808BD6C.26216CC5@bit.nl>

maybe via a Cursor ?

---
CURSOR myCursor IS

   SELECT *
   FROM [table]

---

OPEN MyCursor

   loop

       FETCH myCursor into myRow;
       EXIT WHEN myCursor%NOTFOUND;

      -- Your own counter here and exist when you want

   end loop;
-- You will have to check if you have to close here CLOSE myCursor;

vlee_at_jps.net wrote:

> 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.

--
* remove .spamno when sending a reply * Received on Sat Oct 16 1999 - 13:01:16 CDT