>>Would someone know of how to limit VFP5.0 apps from taking up enormous amounts of memory? What are some of the things I should be looking for, local vs. remote tables? Built in arrays instead of tables at all?
>>
>>I've been running a beta version of my software now for about 25 days and everything is going okay, except the application, after just starting up, gobbles up roughly 6 MB (according to the Win95 system monitor) of available system memory. I have 13 tables, all remotely loaded (3 containing 2000 to 3000 records) and 2 remote views.
>>
>>On my 32MB workstation this isn't much of a problem, but with the user's stations at 16MB each, that is stretching it.
>>
>>Is there somewhere in the docs that describe ways of trimming down memory "footprints"? If you have any suggestions it would be highly appreciated.
>>
>>While my bosses love the app, they aren't going to allow it's full usage until the memory gets trimmed down. This being the first VFP app for this company (and me...), it would mean back to maintaining there old broken-down obfuscated system. I'd like to be able to UPGRADE them...
>>
>> - Iain
>
>How about limiting the number of records per view to say 25 or so?


Use the SYS(3050)function .. This limits the amount of memory Foxpro will use ..

eg .
ForeMem=4096000*2
BackMem=2048000
=SYS(3050,1,m.ForeMem) && set the foreground to 8 megs
=SYS(3050,2,m.BackMem) && set the background to 2 megs