4 ms·
SQLite database locks can be more quickly obtained and released if CPU affinity is set for the database processes, allowing all I/O activity to share the same c
by chasil 3y ago
SQLite database locks can be more quickly obtained and released if CPU affinity is set for the database processes, allowing all I/O activity to share the same cache(es).
I have read (but cannot remember where) that this can increase performance by thousands of DML operations per second.
- ComputerGuru 3y agoThis is really going to be hardware- and OS-dependent. Most schedulers try to avoid changing CPU affinity for active processes, so you're likely looking at the delta for the worst-case scenario rather than the average case. But yes, affinity definitely helps!