Slow reads over VPN

  • Thread starter Thread starter Don Udel \(ETC\)
  • Start date Start date
D

Don Udel \(ETC\)

Have an Access db. When multiple user hit it on the LAN, performance is
fine (response time <= 1 sec). Application is in C# using ADO.NET. When a
remote user tries to access the db (via a VPN), their response time is fine
also. As soon as a user on the LAN access the db, response time goes into
multi second (almost a minute). All of these accesses are reads with
through a dataset (not datareader).

Using a packet sniffer, we find that the file system (client is XP Pro - db
is on a W2K Server) is placing/clearing many lock requests on the .mdb file.

Any thoughts?

TIA

Don
 
Using an Access/JET database like this is Looney tons.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top