Re: TADOTable fetches all rows ?

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

Article #5943

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

#5943

From: Giuliano
Date: Fri, 19 Jan 2001 02:34

27 lines
1733 bytes

On Wed, 3 Jan 2001 12:38:02 +1100, "Peter Beckwith"
<peter@softwareworkshop.com.au> wrote:

>I have an application that connects to an MS SQL 7.0 database that opens a
>table with 82,000 rows in it. When I use BDE (TTable) to open this table it
>takes less than a second but when I open it using ADO (TADOTable) (with the
>lastest patch installed) it takes minutes and seems to be getting ALL of the
>rows in the table when I do an open. I have tried to limit the number of
>rows to 10 but that seems to filter them after all of the table has been
>retrieved.
>
>Does anyone have any ideas on what I've done that's wrong ?
>
>Thanks
>
>Peter Beckwith
>Software Workshop Pty Ltd
>

Hi Peter,

    try to set TADOTable's CursorLocation property to clUseServer instead of
the default value that is clUseClient: maybe this could help you.

Ciao!

Giuliano

Technical Details

Message-ID: <3a67a734.69797523@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!sienna.impulse.net!newsfeed.online.be!newsfeeds.belnet.be!naxos.belnet.be!news.belnet.be!bornews.borland.com!dnews!194.21.61.204

References: <3a67996d_1@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,92103c1a30457cd6,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-01-18 18:40:25 PST
From: gcardinali@remove.adhoc.net (Giuliano)
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: TADOTable fetches all rows ?
Date: Fri, 19 Jan 2001 02:34:39 GMT
Message-ID: <3a67a734.69797523@newsgroups.borland.com>
References: <3a67996d_1@dnews>
X-Newsreader: Forte Agent 1.5/32.451
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 194.21.61.204
X-Trace: 18 Jan 2001 18:38:00 -0800, 194.21.61.204
Lines: 27
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!sienna.impulse.net!newsfeed.online.be!newsfeeds.belnet.be!naxos.belnet.be!news.belnet.be!bornews.borland.com!dnews!194.21.61.204

Reply to Parent Message