RE: SQL over WAN with ADO, how to optimize?
From: Ben (Ben_at_discussions.microsoft.com)
Date: 12/10/04
- Next message: Wart: "Re: Best Pratice-Remore ADO Access"
- Previous message: SÁRINGER Zoltán: "cancel ADO2.8 asynchron queries over WAN, takes long time"
- In reply to: SÁRINGER Zoltán: "SQL over WAN with ADO, how to optimize?"
- Next in thread: David Gugick: "Re: SQL over WAN with ADO, how to optimize?"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 10 Dec 2004 07:31:03 -0800
I hate to give bad news...but
Your specified arcitecture is the worst option of the many available because:
1) You have the most difficult method of applying security exposed to the
world using a thick client model over the Internet.
2) You have the most work being done the farthest distance from your data
store which will never perform well.
I am making these assumptions based on most of your posting; especially your
final question why TSQL is faster than ADO for manipulating data.
I have seen three projects fail abysmially with this arcitecture. It will
not perform or scale.
Practically I would recommend you do some research obout:
1) How a thick client application can be broken into tiers.
2) Architecture options for passing data over the internet.
3) How to secure an application of the Internet.
I am sure this is not good news to you since you are so near completion.
However, I can tell you NOW IS THE TIME TO CUT YOUR LOSSES and ReDESIGN.
Cheers,
Ben
"SÃRINGER Zoltán" wrote:
> 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 ?
>
>
>
- Next message: Wart: "Re: Best Pratice-Remore ADO Access"
- Previous message: SÁRINGER Zoltán: "cancel ADO2.8 asynchron queries over WAN, takes long time"
- In reply to: SÁRINGER Zoltán: "SQL over WAN with ADO, how to optimize?"
- Next in thread: David Gugick: "Re: SQL over WAN with ADO, how to optimize?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
