Re: Efficiency Question - Dlookup vs ADO cmd execution

Absolutely not: the difference beetwen ADO and ADO.NET is so big that
migrating them first to ADO objects won't make things easier at all. Doing
this will only be a pure waste of time.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


"Chris Strug" <hotmail@xxxxxxxxxxxxxx> wrote in message
news:unnktxj3FHA.3296@xxxxxxxxxxxxxxxxxxxxxxx
> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
> wrote in message news:%237EBa3i3FHA.1416@xxxxxxxxxxxxxxxxxxxxxxx
>> Most of the work is done on the SQL-Server side; so usually there will be
>> no real difference between these two. You might gain a little
>> performance when using a stored procedure or a precompiled Select
>> statement but unless you are on a very stressed SQL-Server, you shouldn't
>> mind about these little differences most of the time. To make sure, you
>> can take a look with the SQL-Server Profiler.
>>
>> However, this doesn't mean that there are no possibility of achieving a
>> greater performance and you should always take a deep look at the design
>> on a regular basis. For example, if an index is missing for a critical
>> field, then both the DLookUp and the Select statement will resolve to a
>> lengthy table scan on the SQL-Server.
>>
>> For the future, classical VB is dimmed in favor of .NET, so there is no
>> point of changing these DLookUp or to migrate to a stand-alone VB
>> application if your concern is portability.
>>
>> --
>> Sylvain Lafontaine, ing.
>> MVP - Technologies Virtual-PC
>> E-mail: http://cerbermail.com/?QugbLEWINF
>>
>>
>
> Thanks for that - though I would have thought that changing them to ADO
> command objects would certainly have made migration to a VB.net client
> easier...?
>
> Anyway, thanks for taking time to help.
>
> Regards
>
> Chris.
>


.

Relevant Pages

  • Re: What is the best way to work with SQL SERVER data / tables?
    ... combination of ASP and ADO and SQL-Server and HTML and Client-side ... JavaScript and DOM to be the most successful, rewarding and personally ...
    (comp.databases.ms-access)
  • Re: Ende von ADODB?
    ... Eine Weiterentwicklung ist nicht ... man bei MS vielleicht irgendwann wieder umschwenken, ... Finalversion mit adp und dem Zugriff auf SQL-Server 2005 ... bei ADO angekommen' darum, darauf hinzuweisen, daß ...
    (microsoft.public.de.excel)
  • Re: Access-Zugriff auf MS SQL Server
    ... Als verschiedene Zugriffsarten wurden mir ODBC, DAO, OLEDB, ADO genannt. ... Wenn du nur die Tabellen in den SQL-Server geschoben hast, ...
    (microsoft.public.de.access.clientserver)
  • Re: VBA to import Visual FoxPro DBF in DBC into Access
    ... ADO, despite the fact that you use some ADO objects in your code. ... connection string and the name of a table or saved query/view IIRC. ... myrst.Open strTabName, mycon, adOpenDynamic, adLockReadOnly ...
    (microsoft.public.data.ado)
  • Re: Software testing
    ... If you do check out TestComplete ... to pay attention to our ADO plug-in. ... object will give you access to either the 3 standard MS ADO objects, ... > too short to display all the data, this is a bug. ...
    (borland.public.delphi.thirdpartytools.general)
Loading