Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Use ... Noupdate
Message
De
01/04/2007 09:51:40
 
 
À
01/04/2007 02:11:48
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Divers
Thread ID:
01210928
Message ID:
01210954
Vues:
19
Hi Jos,

>Would the use of the NOUPDATE clause further speed up access to shared tables on a network server that do not require data to be written to them but only read from them?

depends on how broad your definition of "access" is.

One data point if defining "access" very loosely: Opening with noupdate speeded up the *closing* of relatively large lookup tables (4 tables all with cdx, 1 with fpt, together > 500 MB) in a sub-app markedly, while opening/reading was minimally faster. As in that particular environment tables were *always* opened and closed (no discussion wanted by the client) regularly, opening them noupdate whenever possible was quite helpful. Not every situation allows to flip those files as readonly like Walter suggests, as another process might need write access. IAC I'ld use the noupdate if possible.

I *think* measuring was done on vfp8, definitely XP Prof as client OS and no recollection on the server OS. As always, timing your use case/setup is reccomended.

HTH

thomas
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform