General information
Category:
Coding, syntax & commands
Title:
Slow Access with multi users
Environment versions
Network:
Windows 2003 Server
I have been investigating a site that is showing poor performance on data read/write, but basically whole system does not perform well.
EXE is local to workstation as are all graphics files and virtually everything other than DBC/DBF etc., server is 2003 SBS, SMB2 is disabled, current workstation I am testing is Vista but issue is also present on Windows 7 pcs. All data is loaded using SELECT sql commands into cursors NOFILTER (temp folder is on local workstation).
What I have discoverred today is that if I set up side by side installs, one to the "Live" data being accessed by 15 or so users, and one to a test data folder (on save server, same drive) my test data loads significantly faster.
Is there a server setting limiting folder access? I thought VFP tables had no access limits? there should be no record locking going on as this is simply a data load at this point.
Any ideas what could cause this?
Gary.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only