3 ms·
A simple implementation of a queue in SQL will need to acquire an exclusive lock on the table anyway. Although it's not necessary to use locking at the level of
by foldr 4y ago
A simple implementation of a queue in SQL will need to acquire an exclusive lock on the table anyway. Although it's not necessary to use locking at the level of SQL itself: https://news.ycombinator.com/item?id=27482402 https://news.ycombinator.com/item?id=27482402
- TedDoesntTalk 4y agoThe article mentions row-level locking, not full table locking. Big difference in write performance.
- yawaramin 4y agoFor a client-server RDBMS with writes over the network, sure. For an SQLite database with writes to the local filesystem and an order of magnitude better write performance, not so much.