Having a faster database is a matter of trade-offs:
no buffers -> keep the database entirely in memory
no locking or latching -> single-threaded system
no logs -> replication.
Having a faster database is a matter of trade-offs:
no buffers -> keep the database entirely in memory
no locking or latching -> single-threaded system
no logs -> replication.
- Locking (row-level locks that manage concurrent multiple transactions)
- Latching (lightweight locks keep the internals of data structures safe)
- Logging (writing down operations before they happen so they can be recovered)
- Locking (row-level locks that manage concurrent multiple transactions)
- Latching (lightweight locks keep the internals of data structures safe)
- Logging (writing down operations before they happen so they can be recovered)