{"type":"rich","version":"1.0","title":"Kevin Åberg Kultalahti wrote","author_name":"Kevin Åberg Kultalahti (npub106…ptw9x)","author_url":"https://yabu.me/npub106wfyjh9y4wftfz5629w392j58sgr7pg44xuqwq4pz6sjxyvse0qcptw9x","provider_name":"njump","provider_url":"https://yabu.me","html":"I'd be curious to see how this runs on a bare metal VPS - I would expect way way higher throughput.\n\nAnother thing to try would be to batch writes - instead of writing every time something happens you collect writes in a queue and write every 50ms in one big transaction. This should help a lot with write throughput.\n\nReading can be done in the same way.\n\nIf you want to avoid parameter limits you can use JSON1.\n\nLast but not least, analyze the queries using `EXPLAIN QUERY PLAN` to make sure your indices are correctly used."}