Re: How to limit # of rows returned by SELECT
From: Tim Nichols <jmfe_at_ix.netcom.com>
Date: 1996/02/16
Message-ID: <4g29pm$gc1_at_reader2.ix.netcom.com>#1/1
Date: 1996/02/16
Message-ID: <4g29pm$gc1_at_reader2.ix.netcom.com>#1/1
squirrel <squirrel_at_akorn.net> wrote:
>In article <4fo53t$rv7_at_concorde.ctp.com> gumak_at_ctp.com (G. Umakanth) writes:
>
>> >In PowerBuilder, you can use RETRIEVE_AS_NEEDED to retrieve
>> >one full page of data at a time. Other front-ends may have a similar
>
>BTW, this has the potential to be a very bad methodology. You are bound to
>have massive contention any time you have a server which is waiting for
>a command from the client to relase data.
Is this really the case or does PB manage a backend cursor so that the db pages are released?
Tim Received on Fri Feb 16 1996 - 00:00:00 CET