Re: sql question

This is a multi-part message in MIME format. ---------------------------------7154260431995242776815088497 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii -- ============================================================================= --- Herve Delmas ---- delmas@ireq.hydro.qc.ca ============================================================================= ---------------------------------7154260431995242776815088497 Content-Transfer-Encoding: 7bit Content-Type: text/plain From: John Prideaux <alastl@ix.netcom.com> Newsgroups: comp.databases.informix Subject: Re: sql question Date: 13 Oct 1995 12:56:03 GMT Organization: Aladdin Steel, Inc. Mime-Version: 1.0 Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-ID: <45lnl3$1b1@ixnews6.ix.netcom.com> References: <DGCMqn.4Hv@avenger.daytonoh.attgis.com> <DGCz5z.6tz@cix.compulink.co.uk> onlinedbc@cix.compulink.co.uk ("Malcolm Weallans") wrote: >An enhancement to the suggestion made would be to use a SCROLL cursor and >then fetch absolute COUNT-50. Then you could fetch next the rest of the >records > [ much of previous discussion deleted ] I think that scroll cursors take a "snapshot" of the set of rows, so there will be substantial overhead if you are selecting a large number of rows. Other than that, it seems to be a very appropriate suggestion. John Prideaux alastl@ix.netcom.com ---------------------------------7154260431995242776815088497--