Re: Performance problem for VB6 app using ADO over VPN
- From: "Stephen Howe" <stephenPOINThoweATtns-globalPOINTcom>
- Date: Tue, 21 Mar 2006 17:32:08 -0000
I wrote a vb6 app (some time back) utilizing ado to connect to a
sql-server database. This was running on the company's internal network
and everything was fine. But I had to load this app on a Computer which
connectsto our server via VPN. But the performance is so bad from this
computer. It takes a long time to execute even a make a simple database
call.
Gurus....Any Ideas as to how to speed this up?
Nothing simple. You need to make sure the number of server round-trips is
low and when it does do a round trip, it is sending substantial packets.
So Parameter Refresh on Commands should be replaced with pre-worked
parameter setup.
Command objects should be kept long-lived
Server-sided cursors for RecordSets should have Caches that are 256 objects,
etc.
Don't do "SELECT *". Replace with fields needed.
Lock Types should be the bare minimum functionality you need.
Stephen Howe
.
- Prev by Date: Default Maxlength - CLR 2.0
- Next by Date: RE: Best way to find ID of new record
- Previous by thread: Default Maxlength - CLR 2.0
- Next by thread: Best way to find ID of new record
- Index(es):
Relevant Pages
|
|
