Multiuser network response time is very slow
Posted on 2008-10-28
My application accesses .dbf's by a path to a mapped drive on the server. Each user has the map on their desktop machine.
As soon as the second user opens the applications the repsonse time for all users goes from 1-2 seconds to 40 seconds or more.
The application is trying to fill in a datagrid from the records comming back from the server.
I am using .dbf's with properly indexed files to do the access. ie:
set index to aindex.idx
Then I use a do loop to skip trough the table untill the criteria for the selection is no longer met.
I do not lock or need to lock any records as this is read only.
Are there settings in mutilock... cursorproperties... anything that can help with this?
Thanks, Steve R.