It is possible that we could replace the standard sqlite, sqlite3 packages setup with better-sqlite3.
Initially this seemed difficult to achieve and I had some issues with building the better-sqlite3 binary in an Alpine Docker
/ ARM environment. This shouldn't have been difficult because better-sqlite3 ships with specific armv7 binaries for Alpine Linux. Either way, I did manage to get it running in a test branch recently (using a Debian linux container) so maybe that is a good path forward and maybe the import speed can be improved.
Related to improving the indexer transaction import speed issue:
It is possible that we could replace the standard
sqlite,sqlite3packages setup withbetter-sqlite3.Initially this seemed difficult to achieve and I had some issues with building the better-sqlite3 binary in an Alpine Docker / ARM environment. This shouldn't have been difficult because better-sqlite3 ships with specific
armv7binaries for Alpine Linux. Either way, I did manage to get it running in a test branch recently (using a Debian linux container) so maybe that is a good path forward and maybe the import speed can be improved.