Multiuser network response time is very slow

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:
use table.dbf
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.
SRabidouAsked:
Who is Participating?
 
CarlWarnerConnect With a Mentor Commented:
How To Optimize FoxPro Performance on a Network
http://support.microsoft.com/kb/102786/en-us
0
 
Olaf DoschkeSoftware DeveloperCommented:
The first bad thing is you use IDX indexes, CDX indexes are shorter (compact) and you can use many tags in one CDX file which is automatically used. looping through a dbf, even when it's in order by an index is slow. The real proper use of indexes for performance is using them for seeking or rushmore optimazation of where clauses, you use them for ordering purposes only. This makes a table scan even slower than scanning in physical record order. Use SQL Select to retrieve the data fulfilling the "criteria for the selection". Use a View if that data should be updatable.

Bye, Olaf.
0
 
CarlWarnerCommented:
There are lots of ways to tweak for performance.  The use of CDX index file types is preferred and used by all Fox developers I know of.

Also, you may want to consider trying to open the table differently since you are saying it is for read only access anyway.  Try using the NOUPDATE clause when you open that table.

Instead of :
use table.dbf
try:
use table.dbf  NOUPDATE

USE Command
http://msdn.microsoft.com/en-us/library/5e8201te(VS.80).aspx
0
All Courses

From novice to tech pro — start learning today.