Sebastix on Nostr: The current bottlebeck here is now that the sqlite3 database is able to process all ...

The current bottlebeck here is now that the sqlite3 database is able to process all the inserts.
But I guess than can be improved by a factor 1000 when I read this blog https://www.codegenes.net/blog/improve-insert-per-second-performance-of-sqlite/. If applied, inserting 18+ million records in the database will be done in a couple of minutes.

quoting
nevent1q…y4ft

Tinkering with another Nyves.nl (npub1nyv…9nc9) relay (rely by pip (npub176p…vgup)) instance on https://rely.2.nyves.nl on one of my RK1 compute modules. This module with a ARM cpu has only 8 cores, so when I fully load these with running multiple (8) migration scripts it eventually crashes. It's running now with only 4, it seems to be stable. Check and refresh https://rely.2.nyves.nl to see the numbers go up.
Or use nak: `nak count -k 0 wss://rely.2.nyves.nl`
Or use this grimoire (npub1era…skz0) spell `count -k 0 rely.2.nyves.nl`