Re: ADO will get slower and slower the farther into a recordset I go. WHY????

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

Article #5821

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

#5821

From: Yuancai (Charlie) Ye
Date: Wed, 24 Jan 2001 19:56

24 lines
1945 bytes

Hi, Michael:
    Did you try using OLEDB raw interfaces to speed up navigating records.
Here is the excellent site you may be interested in,
http://www.geocities.com/oledbpro/. The site has many OLEDB examples using
both Visual C++ and Borland C++ Builder.

Yuancai (Charlie) Ye

"Michael Crapo" <mcrapo@tng-ida.com> wrote in message
news:3a687d67.14273083@newsgroups.borland.com...
> Hello.
>
> I have test this with Access and SQL Server.  I connect to the
> database using the TADOConnection. Then run a query using TADOQuery
> that is selecting one row from a table.
>
> The recordcount is about 100,000.  I then loop through the Records
> using the TADOQuery::Next() function.  The further into the recordset
> I go, the slower the fields are returned.  I am using defaults for
> borlands defaults for ADO.  Does anyone know what is wrong, and how to
> get around this.  It gets as bad as 1 second to return 1 record.....
>
> TIA for you help
> Mike

Technical Details

Message-ID: <3a6f3212$1_2@dnews>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!skynet.be!newsfeed1.uni2.dk!newssuck.uni2.dk!bornews.borland.com!dnews!208.21.4.213

References: <3a687d67.14273083@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,3df3c77078006232
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-01-24 12:02:26 PST
Reply-To: "Yuancai \(Charlie\) Ye" <yekerui@yahoo.com>
From: "Yuancai \(Charlie\) Ye" <yekerui@yahoo.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3a687d67.14273083@newsgroups.borland.com>
Subject: Re: ADO will get slower and slower the farther into a recordset I go.  WHY????
Date: Wed, 24 Jan 2001 14:56:18 -0500
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: 208.21.4.213
Message-ID: <3a6f3212$1_2@dnews>
X-Trace: 24 Jan 2001 11:50:42 -0800, 208.21.4.213
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!skynet.be!newsfeed1.uni2.dk!newssuck.uni2.dk!bornews.borland.com!dnews!208.21.4.213

Reply to Parent Message