Sunday, July 10, 2011

Peter Vogel on record locking in multi user environment - 2 PDF articles

Creating an effective Update statement in SQL can make all the difference in what data gets saved in a multi-user environment and what sort of performance you’ll get from your application. Peter Vogel discusses record locking and SQL statements.  Read the first article

Peter Vogel examined the issues around locking records and concluded that, most of the time, you dont want to lock your records. In this article, he reviews that discussion and then shows the code that you can use to avoid record locking. Read the second article here

No comments: