Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Flushing data to the tables
Message
From
01/08/2001 13:57:15
 
 
To
01/08/2001 13:50:48
Walter Meester
HoogkarspelNetherlands
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00538379
Message ID:
00538431
Views:
17
>1. Non-commited write buffers. These are rare and can be solved with a FLUSH.
>In a network multi-user environment updates are immediately written to disk and a flush typically not needed.

As I mentioned in the other reply, we do not use buffering.

The application is also standing on the server which holds the data.

>2. Dirty read buffers. though the changes are written to disk, another instance of VFP may hold read buffers of that exact portion of the table that has been changed. At Default the buffers are refreshed at an interval of 5 seconds, but can be adjusted with SET REFRESH. To immediately refresh the buffers you can LOCK the table, a random record or table header to force a refresh.

I did a show of the SET REFRESH value and it is 0. I don't have this setting to be overwritten when I enter in my VFP development. So, I thought the default is 0. So, it is 0 or 5? This would be the same value on the server as I didn't overwrote the default.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform