I hate to be a bringer-of-gloom, but I found I had to reboot the computer to clear everything out of memory. Restarting VFP wasn't enough.
Hope someone else has a good method for you.....
Barbara
>Hello,
>
>I'm trying to benchmark some queries and views, but of course, once I run them, subsequent runs are fed from memory, so my timings are quite off.
>
>I have managed to somehow force vfp or windows to dump its data from memory by running another query that returns about 100,000 records (i.e. select * from requests where iid % 5 = 1).
>
>This, of course, takes some time (which I don't have a lot of right now).
>
>Is there a way to flush the buffers and have vfp work on clean memory other than this or restarting vfp?
>
>Thanks!
>
>Alex