Home     DB      Replicator      CRM      Solutions  

License Policy
One$ DB FAQ
Pricing Policy
Support Overview
Features
Documentation
Compatible Products
Data Migration
Features Comparison
Performance Comparison
Daffodil DB
User Guide > Features > MVCC > Read Committed
 
Read  Committed


Read Committed is the default isolation level in Daffodil DB. When a transaction runs on this isolation level, a SELECT query is able to extract the data committed before the query began and never gets a view of either uncommitted or changes committed during query execution by concurrent transactions. It is to be noted that two successive SELECT statements can see different data, even though they are within a single transaction, when other transactions commit changes during execution of the first SELECT statement. The partial transaction isolation provided by Read Committed level is adequate for many applications, and this level is fast and simple to use. However, for applications that do complex queries and updates, it may be necessary to guarantee a more rigorous and consistent view of the database.

 
Web Database | SQL Database | Embedded Database
©2006 Daffodil Software Ltd. Contact Us | Disclaimer | Sitemap