Add benchmark tests for storing Cardano transactions

[dlachaume]

Content

This PR includes benchmark tests for evaluating the performance of storing Cardano transactions. The PR also includes modifications that improve them. The modifications consist of:

• Adding SQL transactions
• Rework of expand implementation of WhereCondition in sqlite module

Pre-submit checklist

• Branch
  • [ ] Tests are provided (if possible)
  • [ ] Crates versions are updated (if relevant)
  • [ ] CHANGELOG file is updated (if relevant)
  • [x] Commit sequence broadly makes sense
  • [x] Key commits have useful messages
• PR
  • [x] No clippy warnings in the CI
  • [x] Self-reviewed the diff
  • [x] Useful pull request description
  • [x] Reviewer requested
• Documentation
  • [ ] Update README file (if relevant)
  • [ ] Update documentation website (if relevant)
  • [ ] Add dev blog post (if relevant)

store_transactions with 10K transactions

• Current state

  Average time: 154.12 ms

• With modifications: adding SQL transactions

  Average time: 116.35 ms

• With modifications: rework of expand impl

  Average time: 98.078 ms

• With modifications: adding SQL transactions and rework of expand impl

  Average time: 60.628 ms

---

store_transactions with 100K transactions

• Current state

  Average time: 1.5205 s

• With modifications: adding SQL transactions

  Average time: 1.1405 s

• With modifications: rework of expand impl

  Average time: 939.73 ms

• With modifications: adding SQL transactions and rework of expand impl

  Average time: 568.32 ms

---

store_transactions with 250K transactions

• Current state

  Average time: 3.6821 s

• With modifications: adding SQL transactions

  Average time: 2.8220 s

• With modifications: rework of expand impl

  Average time: 2.3101 s

• With modifications: adding SQL transactions and rework of expand impl

  Average time: 1.4331 s

---

store_transactions with 500K transactions

• Current state

  Average time: 7.3614 s

• With modifications: adding SQL transactions

  Average time: 5.5974 s

• With modifications: rework of expand impl

  Average time: 4.5745 s

• With modifications: adding SQL transactions and rework of expand impl

  Average time: 2.8139 s

---

store_transactions with 1M transactions

• Current state

  Average time: 14.772 s

• With modifications: adding SQL transactions

  Average time: 11.004 s

• With modifications: rework of expand impl

  Average time: 9.2098 s

• With modifications: adding SQL transactions and rework of expand impl

  Average time: 5.5863 s

---

store_transactions with 10M transactions

• With modifications: adding SQL transactions and rework of expand impl

  Average time: 55.304 s

Issue(s)

Closes #1656

[github-actions[bot]]

Test Results

    3 files  ±0     43 suites  ±0   8m 22s :stopwatch: -1s   978 tests ±0    978 :white_check_mark: ±0  0 :zzz: ±0  0 :x: ±0  1 072 runs  ±0  1 072 :white_check_mark: ±0  0 :zzz: ±0  0 :x: ±0 

Results for commit 55869cde. ± Comparison against base commit 204c7e47.

:recycle: This comment has been updated with latest results.