rowset size question

Article View: borland.public.delphi.database

Article #1

Back to borland.public.delphi.database Previous Next

From: 6pd
Date: Wed, 01 Jul 1998 00:00

18 lines
1379 bytes

Hiya,

Does anyone know if there's a way to change the number of records that
are returned with each fetch from the BDE when when using Sybase SQL?
As it is now, a query that gives a resultset of 100 records also means
fetch will be called 100 times by the BDE. I would like to reduce that
number of fetches by increasing the number of records that are fetched
with each fetch call.
It seems possible to change this in the ODBC driver for Sybase, by
changing the "rowset size" parameter. But I can't find any such
parameter
in the native driver.

Is there a workaround using the BDE-API maybe?

Dirk.Puis
Dirk.Puis@ping.be

Technical Details

Message-ID: <359A20C4.B6EDCAE9@sy.eni.be>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10288e,a5ec728472042555,start
X-Google-Attributes: gid10288e,public
X-Google-Thread: 10de66,a5ec728472042555,start
X-Google-Attributes: gid10de66,public
X-Google-Thread: 115d96,a5ec728472042555,start
X-Google-Attributes: gid115d96,public
From: 6pd <dirk.puis@sy.eni.be>
Subject: rowset size question
Date: 1998/07/01
Message-ID: <359A20C4.B6EDCAE9@sy.eni.be>
X-Deja-AN: 367725257
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
Content-Type: text/plain; charset=us-ascii
Organization: EUnet Belgium, Leuven, Belgium
Mime-Version: 1.0
Newsgroups: borland.public.delphi.database,borland.public.cppbuilder.database,borland.public.delphi.database.sqlservers