>>i have a big problem with my vfp app. when running on local, it is speed but on LAN, it's very slow. my customers are not satisfied of that.
>>what can i do to make the app be speed ? or what configuration is better ?
>
>I had the exact same problem, turned out I had indexes on fields that shouldn't have had indexes. VFP downloads the indexes which can be very huge when you have the wrong index.
>
>For example you have a table with 1,000,000 records. There is a field "Status" which can be 1 for posted records, and half or the records have this field set to 1. Another field is the purchasedate and that has a few records each day.
>
>Now you execute q query over the LAN (if you do that on your local workstation you will not see any performance problems!):
>
>SELECT * FROM MyTable WHERE Status = 1 AND PurchaseDate = DATE()
>
>If you remove the index on stStatus, the query will perform lightning fast.
>
>Same issue comes up when you have an index on DELETED() and you have a lot of deleted records in the table, it gets superslow over the LAN, while running locally on your computer it would be fast.
Actually a binary index on deleted() is lighning fast.