Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!ncar!noao!asuvax!anasaz!john
From: john@anasaz.UUCP (John Moore)
Newsgroups: comp.databases
Subject: Re: How do you...
Message-ID: <1750@anasaz.UUCP>
Date: 8 Apr 89 14:52:32 GMT
References: <1707@anasaz.UUCP> <513@cullsj.UUCP>
Reply-To: john@anasaz.UUCP (John Moore)
Organization: Anasazi Inc, Phoenix AZ
Lines: 17

In article <513@cullsj.UUCP> gupta@cullsj.UUCP (Yogesh Gupta) writes:
>In article <1707@anasaz.UUCP>, john@anasaz.UUCP (John Moore) writes:
>> Context: Relational Database in Transaction Processing (high performance)
>> (3) Later on, without holding open a cursor, get the NEXT 20 names.
>
>Why not keep the cursor open?  After all, that is what lets the DBMS
>know where you were in your select.

The problem here (note the context) is that there are too many users
to keep one process per terminal. Most RDBMS' have cursors associated
with processes. We want to use a few processes as transaction servers
for lots (>1000) of terminals. Hence the question.
-- 
John Moore (NJ7E)           mcdphx!anasaz!john asuvax!anasaz!john
(602) 861-7607 (day or eve) long palladium, short petroleum
The opinions expressed here are obviously not mine, so they must be
someone else's. :-)