Special

Introducing the “Welcome to Xojo” Bundle!

New to Xojo and looking for guidance? We've put together a terrific bundle to welcome you! Xojo Bundle

This bundle includes six back issues of the magazine -- all of year 21 in printed book and digital formats -- plus a one-year subscription (beginning with 22.1) so you'll be learning all about Xojo for the next year. It's the perfect way to get started programming with Xojo. And you save as much as $35 over the non-bundle price!

This offer is only available for a limited time as supplies are limited, so hurry today and order this special bundle before the offer goes away!

Article Preview


Buy Now

Issue 8.3

COLUMN

Database Concurrency Strategies

Issue: 8.3 (March/April 2010)
Author Bio: Paul Lefebvre has been using REALbasic for 8 years and is the owner of LogicalVue Software, RBDevZone and a founding member of the Association of REALbasic Professionals.
Article Description: No description available.
Article Length (in bytes): 5,679
Starting Page Number: 53
Article Number: 8314
Related Link(s): None

Excerpt of article text...

If you are building multi-user database applications using REAL Studio, then you need to be aware of how to manage concurrency. There are two common ways that concurrency is managed and both have strengths and weaknesses. They are Pessimistic Concurrency Control and Optimistic Concurrency Control.

Pessimistic Concurrency Control

Pessimistic concurrency control is a very rigid way to manage database changes. Generally speaking, when a user requests to change some information in the database (usually a row), you set a database lock on the row. This lock prevents other users from being able to change the row. If another user tries to lock the rock, they will get an error. Once the first users commits their changes, the lock is released so that others may request it.

...End of Excerpt. Please purchase the magazine to read the full article.