News Feed
Jobs Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Brian Swan's Blog:
SQL Server Driver for PHP Connection Options Snapshot Isolation
September 15, 2010 @ 12:21:54

Following up on his previous post about transaction-level isolation with the SQL Server driver, Brian Swan has this new look at an additional option - snapshot isolation.

I'll cover the snapshot isolation level in this post, and (as in my earlier post) I'll look at what happens at the database level when using a particular isolation level (rather than concentrating on PHP data access code).

He introduces snapshots for those not familiar with them - the idea of making a set of data available to other users without having to lock the database in a certain state (also called row versioning). He shows how to turn on the isolation functionality and set it to work with a transaction. With the snapshot created, he shows the SQL needed to fetch the snapshot of data and, of course, how to read it in PHP with the help of the SQL Server driver.

0 comments voice your opinion now!
sqlserver driver isolation snapshot tutorial


blog comments powered by Disqus

Similar Posts

Lars Strojny's Blog: Dependency Injection Container Refactorings, Part One

Kapustabrothers.com: Indexing PDF Documents with Zend_Search_Lucene

NETTUTS.com: How to Create a PHP/MySQL Powered Forum from Scratch

Matthew Weier O'Phinney: RESTful APIs with ZF2, Part 2

Tibo Beijen's Blog: Zend_Form: Building dynamic forms


Community Events











Don't see your event here?
Let us know!


database hack application component series introduction framework performance language package opinion release podcast hhvm facebook symfony2 composer security unittest install

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework