Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Sergey Karimov
  Where is Sergey Karimov?
 Reston
 Virginia - United States
 Sergey Karimov
 To: Eric den Doop
  Where is Eric den Doop?
 Houten
 Netherlands
 Eric den Doop
 Tags
Subject: RE: FLUSHing properly keeps the "crap"...
Thread ID: 50364 Message ID: 50724 # Views: 5 # Ratings: 0
Version: Visual FoxPro 8 Category: Databases, Tables and SQL Server
Date: Sunday, September 05, 2004 5:27:09 PM         
   


Eric, it looks like

FLUSH &&write changes to disc
FLUSH FORCE &&write changes to disc, please, please write

Regards,
Sergey

> > Eric, your reply redoubled my doubt :) Then, what is doing FLUSH command without FORCE clause and for what purpose it is? As concern filename argument it is very suspicious, because as I guess buffering works not with files, but mostly with sectors, clusters, etc.
> > In fact I don’t insist, that FLUSH must write all data to the disc immediately, but It would be nice, that this update is guarantied say in 0.1 second. And of course the updating of second FLUSH command cannot be committed before the first one. It must be a must.
> >
> > Regards,
> > Sergey
> >
>
> FLUSH without the FORCE argument tells VFP to give the data to the OS. The OS then can keep it in a buffer until it finds it has time to write it to disk. So, if your CPU is very busy, it can take 'a while' until the changes are written. I don't know how long 'a while' takes.
> --

>FYI, in VFP9, the FLUSH command has been extended with filename or table name arguments, as well as a FORCE clause telling VFP to instruct the OS to commit changes to disk immediately. Without FORCE, the OS decides when the data is written to disk. If the OS is too busy, it'll queue your request.

> Eric den Doop
> www.foxite.com - The Home Of The Visual FoxPro Experts


ENTIRE THREAD

Using FLUSH Command Posted by Costas Loizou @ 9/1/2004 8:42:27 AM
RE: Using FLUSH Command Posted by Paul Brown @ 9/1/2004 9:41:50 AM
RE: Using FLUSH Command Posted by Costas Loizou @ 9/1/2004 11:40:52 AM
RE: Using FLUSH Command Posted by Pete Sass @ 9/1/2004 11:44:24 AM
FLUSHing properly keeps the "crap" down! Posted by Ken Blum @ 9/1/2004 4:52:42 PM
RE: FLUSHing properly keeps the "crap"... Posted by Sergey Karimov @ 9/2/2004 1:36:19 AM
RE: FLUSHing properly keeps the "crap"... Posted by Eric den Doop @ 9/3/2004 8:33:04 PM
RE: FLUSHing properly keeps the "crap"... Posted by Sergey Karimov @ 9/4/2004 1:30:19 AM
RE: FLUSHing properly keeps the "crap"... Posted by Eric den Doop @ 9/4/2004 2:25:02 AM
RE: FLUSHing properly keeps the "crap"... Posted by Sergey Karimov @ 9/5/2004 5:27:09 PM
RE: FLUSHing properly keeps the "crap"... Posted by Eric den Doop @ 9/6/2004 8:17:08 AM