Thanks Jason - this helps, just in the confirmation that my problem isn't unique.

I've tried playing around with sys(3050) in the past with mixed results, but I wasn't using such large data sets, so I may have better luck. And unfortunately, for now, i can't go to SQL Server for the backend.

Thanks for the thoughts.

Take care,

David

>We ran into the same problem earlier this year...
>
>We found some speed "buy-back" when we graphed various foreground/background memory settings, using SYS(3050). Not surprisingly, there was a distinct setting that worked for almost every machine. Once we found it, we added it to our installation package as a MM registry setting.
>
>Unfortunately, you're correct in your assertion that the only truly reliable speed test is to reboot the pc each time -- otherwise, you run into caching.
>
>If that doesn't help enough, try using remote views. In our case, SQL Server was the only answer as a few of our tables were about to hit the 2GB limit. Once we converted our tables, we had no choice but to use remote views and our speed issues virtually went away (the only remaining ones are due to code, not dbc performance).
>
>Hope that helps,
>---J
>
>>Dear fellow MM users,
>>
>>I have a form which I've been using successfully for about a year. I'm now stress testing it with very large data sets, and it is very slow to instantiate.
>>
>>I'm in the process of tweaking it, including using delayed instantiation of pageframe, optimizing my views, using the coverage profiler, etc. My problem is in testing, and it's a wierd problem:
>>
>>When I first instantiate the form, it takes about 30 seconds to instantiate. Every time after that, it takes only a few seconds to instantiate. If I quite out of VFP and go back in, it still takes only a few seconds to instantiate. If I "do main" it still only takes a few seconds to instantiate. The only way I've discovered to replicate the 30 second lag is to restart my machine. So in order to really test my changes, I need to restart my machine.
>>
>>I'm running VFP 7, MM 7, on Windows XP. I'm running all data locally (i.e. not off a network), and I'm using VFP as the backend.
>>
>>Any thoughts? Also, any additional "speeding up" tips would be appreciated.
>>
>>Thanks,
>>
>>David