Stephen
Are you DisablingControls on the dataset, even though you
may have no datasources bound it seems to speed things up
(esp if the app is CPU bound)
N
----- Original Message -----
From: "Stephen Bertram" <[EMAIL PROTECTED]>
To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
Sent: Tuesday, November 12, 2002 4:55 PM
Subject: [DUG]: TADOQuery performance
I am struggling with the performance of TADOQuery on one machine.
Running a stored procedure that returns around 10000 rows it takes 10.5
seconds to iterate though the rows:
while not qry.Eof do
qry.Next;
On investigation I found that then SQL ran in 0.8 seconds, the first 1000
rows were read in 120 mSec, but each successive 10000 rows took longer to
navigate:
1 0.120 sec
2 0.290 sec
3 0.461 sec
4 0.681 sec
5 0.801 sec
6 0.992 sec
7 1.081 sec
8 1.202 sec
9 1.332 sec
10 1.522 sec
This result was not affected by any combination of CursorLocation, Cursor
Type or LockType. This same procedure runs in under a second on other
machines.
Does anyone have any pointers for the environment, settings or anything else
that may help?
TIA
Stephen
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
