>>>>>Does anyone have examples of how to optimize memory in VFP 5 applications (EXE) that are distributed to several sites. I have a approximately 600 sites, all with various PC's, memory configurations, single user, multi-user, etc. Is there a way to maximize my apps performance with regards to memory when the PC it will be installed on is an unknown.
>>>>>
>>>>>If anyone has any examples of how to accomplish this, I would greatly appreciate it!
>>>>>
>>>>First, what platforms are out there? Is everyone Win95 or NT? For most things the built-in memory managers work pretty well...
>>>
>>>For the most part, all Win95.
>>
>>In general vfp5/Win95 work well together, but then this is where testing is critical. Not only for memory/space issues but at least as importantly for speed issues.
>
>The reason why I brought this up is because during DevCon, I heard a lot of talk about SYS(3050) and how you can set your foreground and background memory buffers and how these settings could significantly improve performance. Apparently, there was an article in the FoxTalk Feb. 1997 issue regarding this and memory. I can see how if you knew the PC you were installing your app on you could test to get the best performance, however, how could something like this be done on multiple installations where you do not know the PC it will be installed on. Can you elaborate more on these issues?
>

I've fiddled with sys(3050), and it came up in 2 Devcon sessions I attended, as well as some UT threads in the past. However, I personally have not found the need to implement it in the two vfp5 apps I have in widespread use. My experience is "first have a problem before trying to fix it" or some such saying...IOW, good and early system testing should determine whether or not you need to worry about trying to manage memory -- ordinarily vfp5/Win95 do a good job...Just find the worst-case machines and test with largest/most complex queries,tables, etc...