Try:
INDEX ON DELETED() TAG DELETED
and see if you see any improvement, running the query from the file server. An article was published some time ago in FoxPro Advisor that talked about the advantages and disadvantages of indexing on DELETED() for Rushmore optimization.
You can create a VFP DCOM server (.exe) that runs on the server and can be called from workstations running your application. Since the DCOM server runs on the same server as the VFP data, access is very fast. The DCOM server can send the results of the query to a temporary table, which the client application can then access.
>>Do you have indexes on the Product field and DELETED()?
>Yes, on the Product field. What do you mean with indexing on DELETED - I never create such an index?
>
>
>>Is this query being run across the network?
>>If the VFP data is sitting on a file server and
>>you are running the query from a workstation, what kind
>>of results do you get if you run the query at the file server?
>
>Actually, I don't have a particular configuration on my mind - of course there is a better performance if it runs on a server or on a single user machine, but it's still not acceptable, because users need this information lots of times during entering, searching, etc.
>
>Zlatko.
Chris McCandless
Red Sky Software