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

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

Article #5807

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

#5807

From: Michael Crapo
Date: Fri, 19 Jan 2001 17:50

14 lines
1351 bytes

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: <3a687d67.14273083@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed1.uni2.dk!newssuck.uni2.dk!bornews.borland.com!dnews!207.14.99.1

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,3df3c77078006232,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-01-19 10:02:23 PST
From: mcrapo@tng-ida.com (Michael Crapo)
Newsgroups: borland.public.cppbuilder.database.ado
Subject: ADO will get slower and slower the farther into a recordset I go.  WHY????
Date: Fri, 19 Jan 2001 17:50:51 GMT
Message-ID: <3a687d67.14273083@newsgroups.borland.com>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: 207.14.99.1
X-Trace: 19 Jan 2001 09:54:51 -0800, 207.14.99.1
Lines: 14
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed1.uni2.dk!newssuck.uni2.dk!bornews.borland.com!dnews!207.14.99.1