Hi,
Filters can be very slow at times, especially multiuser.
Have you tried PACKing all the files.

>Dear Saviours,
>
>I have a situation that requires a solution urgently:
>We have a database situated in a Winows 2000 file server. About 25 users access the various VFP tables from their WinXP or Win2000 stations. Their mode of access is live browsing on the tables. Majority activity include viewing of records as results of a SET FILT command given from the command windows. The tables are of varying sizes. The largest has abut 250,000 records.
>
>For about three weeks now, we have witnessed a decay in access speeds. The database has been confirmed to be valid but for some reason, on and off, psecific users suffer extemely slow response to the SET FILT command or any other access. This is so much so that at times it ends in the users PCs hanging.
>
>So far we have confirmed the the problem is not localized to the PCs at the workstations. We have also confirmed that it is not tied to network or local user profiles. Different users at different times tend not to be able to work.
>
>Anyone: Kindly give us pointers of where the problem is. It has been OK for almost 5 years and it is the first time that we are experiencing this. Is it something to do with FoxPro share limits? The data is growing...
>
>Regards,
>RN