Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using NoUpdate for performance
Message
De
15/08/2001 21:10:07
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
13/08/2001 15:16:56
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00543205
Message ID:
00544484
Vues:
26
>Someone suggested that opening tables at one time with the NOUPDATE clause could actually speed up processes with that table because no buffering was needed. Is that still true in VFP 6.0 and 7.0?

That was me, but the buffering was not the main reason. The reason would rather be the network OS, since it wouldn't have the overhead of applying locks to these files. Now with current networks it may not really work that way - NT may have its own reasons for doing things the way it does them - so you may simply do some testing and see. The test I have in mind would be most probably the reporting, where you may want to manually open the tables involved in an SQL select, and see if there's any difference if they are open with NoUpdate.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform