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.
quotingTinkering with another npub1nyves8d4m86ewyaaw9cxjgfvx2sek40j9q99recvf8zmw0drq6usjh9nc9 (npub1nyv…9nc9) relay (rely by npub176p7sup477k5738qhxx0hk2n0cty2k5je5uvalzvkvwmw4tltmeqw7vgup (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.
nevent1q…y4ft
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`