Dennis,

>I am still trying to find a solution to my VFP query performance problem. My post from a month ago is repeated below. I recently got the network engineering department to attach a sniffer to my port while I was running my test queries in FPD 2.6, FPW 2.6 and VFP 6.0.
>
>The tests are using the same data and code on an NT Server, the only difference is the version of FoxPro. The queries are optimized. We discovered that FPD transfers 700 KB of data from the server to my machine during the queries. FPW transfers 6.5 MB and VFP transfers 40 MB. This explains the large time difference. The question is, why is VFP transfering so much more data?

>Out of curiosity I decided to delete all index tags from all of the databases and rerun the tests. FPD then transfers 98 MB of data from the server to my machine during the queries. FPW transfers 91 MB and VFP transfers 84 MB. The query times are all about the same, 1 minute to 1.5 minutes.

a SWAG, but I think there is something wrong with the indexes which allow rushmore optimization. Did you use MACHINE collated indexes, if not this might be your problem. With a selection of 700 kb out of 98 be sure you don't use an index with a tag on deleted() this only burdens rushmore.

From here it might be wise to add one index at a time, and check how performance and bandwith relates to the other versions.

Good luck,

Walter,