How many active connections? What’s your cpu load / how many cores? I serve about 200 concurrent and I’m about 20-30% of one core/vcpu. Majority of load is reads; sqlite shouldn’t balk at concurrency—using separate db just means you’re shifting some compute over to your database cores.
Discussion
Can’t remember how to check for active connections on the VM. CPU load is constantly 100% on all four cores. Literally constantly.
Unique pubkeys over the last 30 days is 96297
sqlite> select count(distinct author) from event where kind = 1 OR kind = 0 OR kind = 4 AND first_seen > 1671577200;
96297