Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mapperkids
Yak Posting Veteran
50 Posts |
 Posted - 2007-02-01 : 20:06:52
|
| Hi,We have an application which is develped in vb6 and it access the db through the LAN to our sql server 2005. The speed on the LAN is 100mps Ethernet. The application will read/write the sql db tables, the size of the SQL db is about 700 MB. The user that on the local LAN is happy for the speeds. We do have the remote office that is link through a Friction T1 connection to where the SQL server located.But the speed is very slow when running the same application from remote office.It takes a mintue or two just open a table and takes about 5 mins to returned a query result recordset that contains 2000 records.Any way to improve it, or what is the normal practice for this sitution? I'm sure a lot of company have application to access the SQL server data remotely. Is that the HTTP web base is the only solution.Thanks for any suggestions. |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-02-02 : 11:22:14
|
| I'd say you have a problem with your network setup - I connect remotely to a SQL Server and can get 2000 rows over a dial up in 30 seconds. Of course the size of the rows will have some effect on that, but what you are seeing definitely doesn't sound normal. |
 |
|
|
|
|
|
application access db through WAN connection?