preventing data sets fom loading complete tables upon connection

Article View: borland.public.cppbuilder.database.ado

Article #2920

Back to borland.public.cppbuilder.database.ado Previous Next

#2920

From: Bonny Rais
Date: Wed, 05 Mar 2003 01:35

21 lines
1915 bytes

All,

I'm new to C++ Builder so bear with me please.
I have an  ADO query connected to an SQLAnywhere database
via ODBC. If I enavble the Active property during design time, or
when the application starts it takes a long time before I get any response
( ~30 secs). It seems to me that the query is reading all the records from
the result set into memory in order to manipulate it, which seems a waste
to me. I've tried to play with the MaxRecords and CacheSize properties,
to no avail.

Is there any way to  prevent this behaviour? Why can't the dataset be
populated
on demand? The actual usage is to display records from the table using a set
of data acccess controls and a navigator to go back/foreward.

Any help would be appreciated.

Cheers,

Bonny

Technical Details

Message-ID: <b43k8i$s6v$1@news.mch.sbs.de>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!newshosting.com!news-xfer2.atl.newshosting.com!newsfeed.icl.net!newsfeed.fjserv.net!lnewspeer00.lnd.ops.eu.uu.net!bnewspeer00.bru.ops.eu.uu.net!emea.uu.net!newsfeed.siemens.de!news.mch.sbs.de!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,4923d572bd1fd4b5,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-03-04 17:35:22 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!newshosting.com!news-xfer2.atl.newshosting.com!newsfeed.icl.net!newsfeed.fjserv.net!lnewspeer00.lnd.ops.eu.uu.net!bnewspeer00.bru.ops.eu.uu.net!emea.uu.net!newsfeed.siemens.de!news.mch.sbs.de!not-for-mail
From: "Bonny Rais" <bonnyr@optushome.com.au>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: preventing data sets fom loading complete tables upon connection
Date: Wed, 5 Mar 2003 12:35:11 +1100
Organization: Siemens Business Services
Lines: 24
Message-ID: <b43k8i$s6v$1@news.mch.sbs.de>
NNTP-Posting-Host: 140.231.0.35
X-Trace: news.mch.sbs.de 1046828115 28895 140.231.0.35 (5 Mar 2003 01:35:15 GMT)
X-Complaints-To: abuse@siemens.de
NNTP-Posting-Date: Wed, 5 Mar 2003 01:35:15 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106