Walter,
Thanks for the feedback.
I didn't know when the UT discussion started. I'll try to clarify that.
No, I didn't restart the computer. I understand your point, but I don't think it's valid. VFP caches table/CDX info, we know that. The OS caches it's own disk info. Does it cache network data? It would be problematic. Since my last USE, the table structure, CDX structure, and all the data could be different. My experimentation with the WAN where things get measured in minutes, not seconds, convinced me that that I was seeing valid results.
There were times, however, when a WAN activity would happen very fast. It was rare, and I attributed that to some caching between the remote file server and me. I hope to learn more about that.
I have noticed real life apps running snappier. In real life, we don't reboot to test, so whatever's going on, removing the DelTag is better.
>Charlie,
>
>I did a fast-read on the article and have two remarks:
>
>1. The discussion about the deltag was held BEFORE the article in FPA.
>
>2. Did you take care of buffered data within 'Testing the theory' ? if a select statement is run the second time. it takes considerably less time to complete, due to buffers on the OS level. It is a good idea to restart the computer before you test the two situations. The first time you can check the query without the deltag before you check the one with a deltag. After a restart you test the one with the deltag first. In this way you can get more reliable responsetimes.
>
>Walter,