Myles That was what i thought but the thing that surprised me was that it unprepared it before it executed it (I assume it relied upon the compiler cache), Also a general question ADO MSSQL users use the OLE-DB driver or ODBC?. Ive actually gone down the track of using kbmMemtable as the in memory dataset (loading it from a unidirectional ADOCommand) and resolving using kbmMemtable delta handler and a ADOCommand to execute the SQL. You basically could say I've reengineered the Static/Client dataset but I'm a lot happier (no more 'Multiple OLE-DB Op......' error messages), and I can total control the update and resynch logic
s'pose my next step would be to change the Load and Excute Datasets to dbexpress and say bye bye to ADO Totally Neven ----- Original Message ----- From: "Myles Penlington" <[EMAIL PROTECTED]> To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]> Sent: Tuesday, November 12, 2002 10:05 PM Subject: RE: [DUG]: On the subject of ADO > 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/ > --------------------------------------------------------------------------- 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/
