Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Any reason to buffer local views?
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00458169
Message ID:
00458368
Vues:
19
>>>There is a problem with views though, in that the view record in the DBC is temporary locked when the view is opened. If two users are opening the view at the same time, one may fail. So many developers put their views in a separate DBC, and keep that DBC on the local machine. So there is one DBC on the server for the tables, and each user has their own copy of the view DBC.
>>
>>Is this only when the view is opened - not requeried?
>>
>
>I don't believe so because the view structure is already known and getting that information from the DBC is not necessary.

Did you mean to say, "I believe so"? Thereby answering his question as -- Yes the record is only locked when the view is opened and not when requeried.
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform