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

Update performance numbers in README #75

Open
noteflakes opened this issue Jun 13, 2024 · 1 comment
Open

Update performance numbers in README #75

noteflakes opened this issue Jun 13, 2024 · 1 comment

Comments

@noteflakes
Copy link
Contributor

The sqlite3 gem version 2.0 is significantly faster than before. The benchmark results in the README should be updated to reflect that.

@joshuapinter
Copy link

@noteflakes This was a good shout. I came looking at extralite mostly because the memory consumption of a big import via sqlite3 was massive for us. 32 GBs or something and we were only moving towards bigger and bigger imports we were doing.

Seeing this comment you wrote made me check which version of sqlite3 we were using. We were on 1.7.3 so after upgrading to 2.0.2 that memory consumption nearly disappeared on the same import. I noticed an entry in the CHANGELOG saying something about a memory leak that they fixed.

So, in addition to the speed performance, it looks like the memory consumption has been greatly improved in sqlite3 version 2 as well.

When we have more time, I'd still like to check out extralite to see what kind of performance gains we get but also just a nicer interface to work with, it seems. Very well thought out and documented.

Thanks for making this comment here.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants