Nostr Web Client

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.

0xtr 2y ago

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;

Reply to this note

Discussion