input-output-hk / mithril

Stake-based threshold multi-signatures protocol
https://mithril.network
Apache License 2.0
122 stars 37 forks source link

Use SQLite transactions when inserting `Cardano Transactions` and `Block Range Roots` #1656

Closed jpraynaud closed 4 months ago

jpraynaud commented 4 months ago

Why

We can have a better insertion throughput if we use transactions in SQLite (see https://stackoverflow.com/questions/1711631/improve-insert-per-second-performance-of-sqlite). This can be used to accelerate the insertion on Cardano transactions and block range roots on the signer and aggregator.

What

Create insert queries inside a transaction when importing the Cardano Transactions and block range roots.

How

After