Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Inconsistent SQL results
Message
From
08/08/2003 06:25:36
 
 
To
07/08/2003 13:43:31
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00817760
Message ID:
00818112
Views:
30
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) 
&& before for worse case without write lock
    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.
Previous
Reply
Map
View

Click here to load this message in the networking platform