 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Mark
Guest
|
 Posted: Mon Jan 26, 2004 10:14 pm Post subject: Using Delphi 7 ADO to access SQL Server accross a WAN |
 |
|
I am using a Delphi 7 Tadoquery component to access a Sql Server
database over a Wide Area Network. When I do a Tquery.open to open a
query and return 1 record using its primary index it takes 1-3 minutes
to display the data on a form. The sql statement I am using is
'Select * from CATS WITH (Index(IX_CATS)) where Cats_id = 6937'.
This statement takes 1-2 seconds when executed on the same Local Area
Network where the Sql Server is loaded. What is degrading performance
over the WAN? How sould I troubleshoot? Should I use DBexpress, or
some other data access method instead of ADO? Can I change some of
the connection parameters to make an ADO connection perform better
over the WAN? Please help?
Mark Catheline
[email]MarkCatheline (AT) juno (DOT) com[/email]
|
|
| Back to top |
|
 |
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
