Thanks Barbara,

That's pretty much what I thought but wondered if someone else knew of a trick that would do it.

ALex

>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