So as per the MS SQL docs, I read this as SQL creating a temporary stored proc to execute the SQL statement. I think this is a ADO connection parameter from memory, so it can be turned on and off.
Myles. -----Original Message----- From: Neven MacEwan [mailto:neven@;mwk.co.nz] Sent: Tuesday, 12 November 2002 5:27 p.m. To: Multiple recipients of list delphi Subject: [DUG]: On the subject of ADO Hi Can ayone explain why ADO does this (MSSQL7, TADOCommand, CommandText = "Select Applicator.ApplicatorID, Applicator.Name FROM Applicator Applicator ") declare @P1 int set @P1=NULL exec sp_prepare @P1 output, NULL, N'SELECT Applicator.ApplicatorID, Applicator.Name FROM Applicator Applicator', 1 select @P1 then sp_unprepare 20 finally SELECT Applicator.ApplicatorID, Applicator.Name FROM Applicator Applicator Huh? Neven ----- Original Message ----- From: "Stephen Bertram" <[EMAIL PROTECTED]> To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]> Sent: Tuesday, November 12, 2002 5:12 PM Subject: RE: RE: [DUG]: TADOQuery performance Hi Myles The machine has 50 Mb of Ram with the current usage at 132 Mb. The point is that the times AREN'T cumulative - each time is the time to iterate through 1000 rows. It suggests that the Dataset is reading the rowset from row 1 each time the qry.Next is executed. ie = no cursor. Any thoughts? Stephen -----Original Message----- From: Myles Penlington [mailto:myles@;ams.co.nz] Sent: Tuesday, 12 November 2002 5:08 p.m. To: Multiple recipients of list delphi Subject: RE: [DUG]: TADOQuery performance Unless I am reading your results wrong (maybe?), it seems it takes about 150ms on average to read each set of 10000 rows. Results seem quite linear. Presuming you have a problem, and it seems the machine is the issue, then how much memory does it have - is it paging/thrashing a lot? What about the ADO version installed on the machine? Are they all the same eg MDAC 2.5, 2.6 or 2.7 etc. A slower CPU or perhaps it is getting network errors? Although you seem to hint that network is working okay. Myles. -----Original Message----- From: Stephen Bertram [mailto:StephenB@;ensynergy.co.nz] Sent: Tuesday, 12 November 2002 4:55 p.m. To: Multiple recipients of list delphi 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/ --------------------------------------------------------------------------- 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/ --------------------------------------------------------------------------- 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/
