Can any big brain devs help me figure out how to speed up this import?
Just saving blocks and txns into a db...
But at the current pace it's gonna take two weeks to finish
https://github.com/utxo-one/bitcoin-analytics-api/blob/master/src/import/import.service.ts
- it looks synchronous. parallelizing the block processing should quickly speed it up
- looks like your orm is only doing single inserts. bulk inserts would be faster
*normal brain here but have used these techniques successfully. also I typically avoid orms in favor of sql for greater control over the db, but ymmv.
Ok great many things to improve ty good sir 🫡
excited to see what you’re cookin up! 🤙
I hope everyone is proud that I dumped PHP
It wasn't easy, it's still the best language
Cc nostr:npub137c5pd8gmhhe0njtsgwjgunc5xjr2vmzvglkgqs5sjeh972gqqxqjak37w
