Sergey
In your article you say: It also helpful to call SYS(1104) after code that process large tables to clear VFP memory cache and buffers.
My routine runs many Select-SQL lines, usually processing large tables. I am wondering how to go about implementing this suggestion.
The help file (for VFP9) warns: The use of SYS(1104) will slow performance in applications that have a large number of buffered tables open.
I guess that instead of calling SYS(1104) after each Select-SQL line that deals with large tables, it may be better to call it occasionally through the code.
Regards
Cyril
>Cyril,
>
>It's known problem with VFP8 and earlier. See
http://www.berezniker.com/content/pages/visual-foxpro/not-enough-memory-file-map-error-1150>
>>A long, data intensive operation fails with the message: Insufficient memory to continue
>>The PC has 2GB RAM, 74 GB free disk space, and runs Windows XP SP2. Intel Core 2 Duo.
>>