We are experiencing a slowdown of access to Foxpro tables on an NT network with approximately 80 users. The largest table contains 1 million plus records. Using this as a test table from development it is taking 10-20 seconds to even display straight browse commands results on the screen and these used to be instant. Are we being impacted by a possible cdx file problem even though we have opened the table for testing with no indexing open? Any input as to what may be causing this problem would be appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
slow access to network tables
- Thread starter dakotafox
- Start date
Do you have a lot of deleted records and is set deleted on?
Does your program open the table with no index set, if not you may still have a cdx problem? Is there something else going on with your network that might be causing a lot of traffic? Have you checked you network hub/switch for collisions?
Does your program open the table with no index set, if not you may still have a cdx problem? Is there something else going on with your network that might be causing a lot of traffic? Have you checked you network hub/switch for collisions?
- Status
Similar threads
- Locked
- Question
