>Hello,
>
>I am hoping someone can help me. I have a customers application that they have been using for 3 years, over the last 6 months searching data searches have gotten very slow. The data is located on a Windows 2003 server, the largest table is on 8 meg. When a single user is accessing the data the search takes less then 2 seconds, however if more then one person is in the database the searches can take up to 45 seconds.
>
>I have tried:
>1) Reindexing the tables
>2) Deleting and recreating the indexes
>3) Using Gendbc to recreate the dbc, indexes and tables and copied in the data
>
>None of this has had any effect. The searches are on indexed fields and I am using a browse for command to do the search.
You could try temporarily disabling antivirus on both the server and the workstation(s), to see if that makes a difference. If it does, you could experiment with excluding VFP file types and the temp files folder from antivirus real-time scanning.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up