4 ms·
> A great deal of complexity of DBMS is in granularity of locks, its escalation/deescalation, and shared use performance. Agreed. > My understanding is that S
by sicp-enjoyer 5y ago
> A great deal of complexity of DBMS is in granularity of locks, its escalation/deescalation, and shared use performance.
Agreed.
> My understanding is that SQLite suppprts only system locks
Is this any different than a process blocking on a mutex while another writes to a shared resource? I understand DBMS do it better, but I don't see why it's viewed as a non-starter for SQLite.