SQL over WAN with ADO, how to optimize?

From: SÁRINGER Zoltán (asdf_at_asdf.hu)
Date: 12/10/04 

Date: Fri, 10 Dec 2004 16:03:06 +0100

Hello,

this become a common question... is any common answer ?
I want to use VB6 application to connect SQL2000 via ADSL 512/128.., and the
half of the code have done already, I'm using ADO 2.8.
All bussiness logic on the thick client side.., and I choosed ADO becouse I
used these events to audit changes (instead of writing lot of triggers), so
everything is doing by the client. I minimized the requests to sql, but
seems extremly slow via internet.

Try to speed up, how?
What connection and recordset parameters (included the most detailed
parameters too..!) should use for:
1) common record listing queries?
2) update

What is your opinion, if sql server is used for only store data with ADO
only, is it a real poor programming modell, doesnt exist any advantage?

Why is it faster UPDATE a record with TSQL than ADO ?

Relevant Pages

  • SQL over WAN with ADO, how to optimize?
    ... this become a common question... ... All bussiness logic on the thick client side.., and I choosed ADO becouse I ... What connection and recordset parameters (included the most detailed ... Why is it faster UPDATE a record with TSQL than ADO? ...
    (microsoft.public.vb.database.ado)
  • SQL over WAN with ADO, how to optimize?
    ... this become a common question... ... All bussiness logic on the thick client side.., and I choosed ADO becouse I ... What connection and recordset parameters (included the most detailed ... Why is it faster UPDATE a record with TSQL than ADO? ...
    (microsoft.public.sqlserver.programming)
  • Re: Enumerate uses in ad from text file
    ... It sounds like it could be the Common ... You would use ADO to search AD for the users ... Microsoft MVP Scripting and ADSI ...
    (microsoft.public.windows.server.scripting)
  • Re: SQL over WAN with ADO, how to optimize?
    ... Try SocketPro at www.udaparts.com. ... Fast accessing all of remote data sources anywhere with SocketPro using ... > this become a common question... ... > half of the code have done already, I'm using ADO 2.8. ...
    (microsoft.public.data.ado)
  • Re: SQL over WAN with ADO, how to optimize?
    ... Try SocketPro at www.udaparts.com. ... Fast accessing all of remote data sources anywhere with SocketPro using ... > this become a common question... ... > half of the code have done already, I'm using ADO 2.8. ...
    (microsoft.public.sqlserver.programming)
Loading