Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Locking mechanism on data dictionary update
Message
De
23/03/2011 11:49:01
 
 
À
23/03/2011 11:16:25
Information générale
Forum:
ASP.NET
Catégorie:
Autre
Versions des environnements
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01504666
Message ID:
01504683
Vues:
34
>I'm not sure I quite understand the scenario you've laid out. Could you explain it differently and throw in a bit of code to help clear it up?

When I adjust the data dictionary, this may require to reload an item in the data dictionary collection I have. When doing that, for a fraction of a section, an item in the collection might not be available to an ongoing hit in progress. Because, I have four application pool instances for the Web site, while one hit is updated the data dictionary, another one might still be in progress. Thus, because the Data class makes use of the collection, it may generate an error in the related process. So, the only way I see to resolve that issue would be to verify in the Data class for the availability of the data dictionary. So, when the data dictionary will be in update mode, I will know about it in the Data class and wait for its availability. This, of course, will simply help to diminish to amount of potential situations, but it will probably resolve most of the potential ones. Because, even if the Data class detects that the data dictionary is available, during its process, it might become unavailable again. But, this is unlikely to happen because only one person can update the data dictionary. And, when that happens, it is usually one item at a time, giving the other hits in progress more than enough time to complete.

The perfect architecture to support such flexiblity would be to install a double lock mechanism. But, I am afraid of dead locking issue here.

Any comment on this type of situation?
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform