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/
