Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Performance Issue
Message
 
To
21/08/2009 14:41:16
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01419605
Message ID:
01419608
Views:
117
>Hello All
>I have been using an in house designed contact manger using about 30 tables. We could have up to 10 clients running the interface working with the common data. In the past few years our main table contacts.dbf has grown from 10,000 to 20,000 records. The data is on a Win 2003 server. For the past few months I have gotten complaints from users about performance. Lets say a search is done and what took a few seconds in the past could now consume 20 seconds. This may not seem much but all that time does add up as far as user productivity. I believe I have ruled out cabling, switches, hardware, and viruses on the network. Is their some sort of utility that is commonly used to determine where the slowdown is actually occurring? Would MS Network Moitor help? Thanks.

20000 records do not sound like a huge table.
What is search creteria, and how exactly do you allow users to "search"?
Did you try to reindex?
Did you try to pack?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform