>I need to run some speed tests and check results and rushmore optimisation.
>
>Is there anyway to reset the environment completely so that I can run repeated tests without restarting the VFP IDE every time?
>
>otherwise obviously my 2nd and subsequent queries do not produce valid results as data etc. held in memory.
>
>I have tried;
>Close Tables
>Close Databases
>Close ALL
>Clear ALL
>
>Thanks.
>
>Gary.

You may also add sys(1104) in between the calls, but I think it's still may be invalid. You may need to re-open VFP every time to be completely sure of clean tests.