Site Menu
- Home
- Products
- NexusDB
- Nexus Quality Suite
- NexusDB Drivers & Connectors
- Nexus Remoting
- Nexus Memory Manager
- Some of our Customers
- Testimonials and use(r)s
- Downloads
- Documentation
- Support
- Pricing & Orders
- About
- Community
- My Nexus
- Recently Updated ...
- Search...
- Site Login
Search
Snapshot Transactions


In addition, NexusDB supports SNAPSHOT isolation level. Snapshot transactions are always read only. They never place any locks. Cursors in the context of a snapshot transaction see the database in exactly the (READ COMMITTED) state it was in at the moment the transaction was started. This is achieved by using a block level multi-versioning system. SQL SELECT statements will automatically be executed in the context of a snapshot transaction if no transaction is already active for that database. This guarantees that even long running queries will see a consistent view of the database without placing any locks. With this setup we have been able to achieve an almost perfect degree of concurrency, since readers never block writers. Whereas writers block readers only for an extremely short time to execute UPDATE/COMMIT.
Questions? Problems?
- Interested to buy but something put you off?
- Can't find what you're looking for?
- Have a suggestion?
Let us know. If you're having trouble contacting us, please check here.
Site Updates
- May 27 2025 - 2:55pm
- May 14 2025 - 12:32pm
- Mar 19 2025 - 9:52pm
- Mar 14 2025 - 11:23am
- Mar 13 2025 - 11:42pm