Hi Cyril,

There's no hard rule on how often to call SYS(1104). You'll have to find a balance between performance and buffer memory usage that could cause the error.

BTW, in VFP9 SYS(1104) allows to purge buffers for specific work area (the second optional parameter).


>
>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.
>