Re: TADOStoredProc


Its not a CPU cycle issue. It is an issue with How ADO handles the change in
the SQL. Every time you add to the SQL it sends those changes back to the
database. That is not efficient so don't use Add() set All the commandtext or
the SQL.text property


TAdoQuery sets the SQL using a Tstringlist while TadoDataset uses a
Widestring;
While both can set the SQL in the underlying ADO dataset there is a
performance penalty if you set it one line at a time like
AdoQuery.sql.Add('this line');
leads you to do

But it's always worth remembering that the performance penalty for each
additional CPU operation is only nanoseconds, rather than the milliseconds
for each additional disk access.

I'm not saying that tAdoDataSet and tAdoCommand aren't a "better fit" to
the underlying ADO architecture, just that simply replacing all tAdoQuerys
and tAdoStoredProcs in an under-performing program probably /won't/ give a
significant speed boost.

( But I still pre-calculate invariants and store them in local variables
before every FOR loop :) )

--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages

  • Re: Using parameters with the low level ADO API, trying to avoid the memory leaks.
    ... MS ADO passes SQL directly to OLEDB provider. ...
    (borland.public.delphi.database.ado)
  • Re: Programmatically changing a SQL view in a ADP
    ... One of the differences between DAO and ADO is that DAO combines data ... there isn't a way to do this successfully with ADOX. ... But T-SQL, SQL Server's ... Dim cn As ADODB.Connection ...
    (microsoft.public.access.modulesdaovba)
  • Re: Smartest way toa add records manually
    ... class modules to represent tables, collections, etc., and started isolating ... we've transitioned from Access as a back end to SQL Server as ... Then I discovered why I transitioned to ADO. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Prevent Commands in SQL Update
    ... I am not familiar with PHP, but ADO is ADO ... ... sinple way to clean an SQL statement. ... Server-side validation of ALL user input MUST be done, ...
    (microsoft.public.data.ado)
  • Re: dumb previous question - repost
    ... dataaccess technology not a datatransfer technology although it can be used ... Here is what I do right now with com ado from ... > With my com ado loop above I can transfer 5000 records ... > from sql server to Access in a few seconds. ...
    (microsoft.public.dotnet.framework.adonet)