Re: SQL over WAN with ADO, how to optimize?

From: Yuancai \(Charlie\) Ye (yekerui_at_yahoo.com)
Date: 12/11/04 

Date: Sat, 11 Dec 2004 11:04:49 -0500

Hi,
    Try SocketPro at www.udaparts.com. That is solution. See the site
http://www.udaparts.com/articles/dialupdb.htm 

-- 
Yuancai (Charlie) Ye
Fast accessing all of remote data sources anywhere with SocketPro using
batch/queue, non-blocking and parallel computation
See 30 well-tested and real OLEDB examples
at http://www.udaparts.com
"SÁRINGER Zoltán" <asdf@asdf.hu> wrote in message
news:%23UMMSls3EHA.3756@TK2MSFTNGP14.phx.gbl...
> 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

  • 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.vb.database.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)
  • 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)
  • 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)
  • 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)
Loading