Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

SQLite - Now 50% Faster!

DZone's Guide to

SQLite - Now 50% Faster!

· Performance Zone
Free Resource

Discover 50 of the latest mobile performance statistics with the Ultimate Guide to Digital Experience Monitoring, brought to you in partnership with Catchpoint.

SQLite developer Richard Hipp posted recently that the database has become 50% faster than it was 16 months ago. According to the SQLite blog, the database engine, tested with the "'speedtest1 --size 5' workload on Ubuntu 10.13 and gcc 4.8.1 with -Os", now performs 50% more tasks in the same amount of CPU cycles.

What's really interesting is that no one improvement significantly changed SQLite's speed. A combination of plenty of low-end improvements made it work more efficiently, with single changes affecting speed only fractions of a percent.

The 50% faster number above is not about better query plans. This is 50% faster at the low-level grunt work of moving bits on and off disk and search b-trees. We have achieved this by incorporating hundreds of micro-optimizations. Each micro-optimization might improve the performance by as little as 0.05%. If we get one that improves performance by 0.25%, that is considered a huge win. Each of these optimizations is unmeasurable on a real-world system (we have to use cachegrind to get repeatable run-times) but if you do enough of them, they add up.

One-tenth of the improvements to speed have come since the last update, and all tests pass on the new release, so, as Hipp says, "we are confident that we didn't break too much."

Find out more from Hipp's post , and from the SQLite website .

Is your APM strategy broken? This ebook explores the latest in Gartner research to help you learn how to close the end-user experience gap in APM, brought to you in partnership with Catchpoint.

Topics:

Opinions expressed by DZone contributors are their own.

THE DZONE NEWSLETTER

Dev Resources & Solutions Straight to Your Inbox

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

X

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}