Posts
Although this began as a usual book review, it quickly grew into an
all-encompassing article as a result of the additional and extended
commentary
While concurrency is always covered as part of a book on SQL Server, this title is totally dedicated to it. Exaggerated one might say; quite the opposite and with good reason I would say. It aims to raise awareness of this frequently underrated subject whose incomprehension can result in massive performance complications.
The problem lies in that no matter how well designed your application, database, or SQL queries are, all working harmonically in isolation, going multi-user without putting considerable effort into understanding concurrency (and how your specific DBMS goes about it), will sooner or later lead your edifice into collapsing, shaken by performance degradation, unacceptable waiting time or even corrupted data state.
So this is where this slim guide comes in, to properly educate anyone working with the RDBMS in keeping out of trouble, building a greatly performing multi-user application and being ready to troubleshoot when the need arises.
full book review on i-programmer
While concurrency is always covered as part of a book on SQL Server, this title is totally dedicated to it. Exaggerated one might say; quite the opposite and with good reason I would say. It aims to raise awareness of this frequently underrated subject whose incomprehension can result in massive performance complications.
The problem lies in that no matter how well designed your application, database, or SQL queries are, all working harmonically in isolation, going multi-user without putting considerable effort into understanding concurrency (and how your specific DBMS goes about it), will sooner or later lead your edifice into collapsing, shaken by performance degradation, unacceptable waiting time or even corrupted data state.
So this is where this slim guide comes in, to properly educate anyone working with the RDBMS in keeping out of trouble, building a greatly performing multi-user application and being ready to troubleshoot when the need arises.
full book review on i-programmer
Comments