Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Improve SQLite plugin performance by using transactions #81

Closed
Martin-Idel-SI opened this issue Dec 19, 2018 · 1 comment
Closed

Improve SQLite plugin performance by using transactions #81

Martin-Idel-SI opened this issue Dec 19, 2018 · 1 comment
Labels
enhancement New feature or request help wanted Extra attention is needed

Comments

@Martin-Idel-SI
Copy link
Contributor

The default storage plugin using an SQLite database currently writes every message to the database immediately. This has the benefit that on errors no messages are lost, but it incurs a performance overhead.

It would probably be best to use transactions and buffer messages, writing several at once. Since this behaviour is specific to the plugin, it might be best to implement a config for the storage plugin which can be edited by the user providing all parameters to tweak performance and memory usage.

@cottsay cottsay added enhancement New feature or request help wanted Extra attention is needed labels Dec 27, 2018
@Karsten1987
Copy link
Collaborator

closing this as a potential duplicate of #123 which has some more info it. @Martin-Idel-SI feel free to re-open this in case you consider it two separate problems.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request help wanted Extra attention is needed
Projects
None yet
Development

No branches or pull requests

3 participants