Skip to content

Instantly share code, notes, and snippets.

@sriramster

sriramster/transaction.md

Last active October 28, 2019 18:05
Show Gist options
  • Save sriramster/2f9bdd620730855e6172c7136b56d6fc to your computer and use it in GitHub Desktop.
Save sriramster/2f9bdd620730855e6172c7136b56d6fc to your computer and use it in GitHub Desktop.
Download ZIP
Raw
transaction.md

Rosbag2 Transactions v0.1

Sqlite transaction based querying model.

Things to take care off

  • Rosbag2 sqlite plugin does'nt work based on sqlite transactions.
  • To enable optimized querying or writes within sqlite transactions are the best options.

Some URL references on transactions are below:

Pragma settings

  • Sqlite cache_size needs to be increased to support this

Perfomance measurements

TBD

Changes to the code flow path to prove that transactions work better than is as shown in the diagram below.

alt text

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment