Hi Aleksey,
use SYS(1104) kill VFP performance ( on WAN it put VFP not direct usable )
for every Table ( also for static table ).
I suggest to VFPT to implement this ( meta language ):
IF NOT REQUEST_DATA_IN_CACHE OR FTIME(FILE_DATA)>LAST_REFRESH
LAST_REFRESH = FTIME(FILE_DATA)
REFRESH_FILE_DATA_IN_CACHE
ENDIF
RETURN_REQUEST_DATA
and add a CURSORPROPERTY for enable/disable it.
If FILE_DATA ( not cursor ) is Read_Only ( static file )
VFP can put CURSORPROPERTY to fixed disabled.
I think FTIME(FILE_DATA) is fast, also on network LAN/WAN,
and data used is correct.