Why use a READ UNCOMMITTED isolation level?
stackoverflow.com
Why use a READ UNCOMMITTED isolation level?
数据库基本支持五种标准 SQL 事务级别：未提交读取、已提交读取、可重复读取、快照隔离和可序列化
#database #transaction
The advantage of using an ID is that because it has no meaning to humans, it never needs to change: the ID can remain the same, even if the information it identifies changes. Anything that is meaningful to humans may need to change sometime in the future—and if that information is duplicated, all the redundant copies need to be updated. That incurs
... See more
I can't stop thinking about this blog post where they replaced Redis with SQLite—and surprisingly, SQLite was faster!
What's interesting is that Redis was running locally, SQLite was storing the data on disk. So it was memory (Redis) vs disk (SQLite), but Redis needed to communicate through IPC.