To reduce load on SQLite — which limits write transactions to one commit at a time even with WAL mode — we can queue up certain writes, such as writes for the high-volume license.lease_extended and node.heartbeat_ping events (depending on TTL).
Queuing should add jitter, to reduce the thundering herd problem.
To reduce load on SQLite — which limits write transactions to one commit at a time even with WAL mode — we can queue up certain writes, such as writes for the high-volume
license.lease_extendedandnode.heartbeat_pingevents (depending on TTL).Queuing should add jitter, to reduce the thundering herd problem.