DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
Refcards Trend Reports Events Over 2 million developers have joined DZone. Join Today! Thanks for visiting DZone today,
Edit Profile Manage Email Subscriptions Moderation Admin Console How to Post to DZone Article Submission Guidelines
View Profile
Sign Out
Refcards
Trend Reports
Events
Zones
Culture and Methodologies Agile Career Development Methodologies Team Management
Data Engineering AI/ML Big Data Data Databases IoT
Software Design and Architecture Cloud Architecture Containers Integration Microservices Performance Security
Coding Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Partner Zones AWS Cloud
by AWS Developer Relations
Culture and Methodologies
Agile Career Development Methodologies Team Management
Data Engineering
AI/ML Big Data Data Databases IoT
Software Design and Architecture
Cloud Architecture Containers Integration Microservices Performance Security
Coding
Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance
Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Partner Zones
AWS Cloud
by AWS Developer Relations
Building Scalable Real-Time Apps with AstraDB and Vaadin
Register Now

Trending

  • You’ve Got Mail… and It’s a SPAM!
  • Boosting Application Performance With MicroStream and Redis Integration
  • Mainframe Development for the "No Mainframe" Generation
  • Application Architecture Design Principles

Trending

  • You’ve Got Mail… and It’s a SPAM!
  • Boosting Application Performance With MicroStream and Redis Integration
  • Mainframe Development for the "No Mainframe" Generation
  • Application Architecture Design Principles
  1. DZone
  2. Data Engineering
  3. Databases
  4. SQLite - Now 50% Faster!

SQLite - Now 50% Faster!

G. Ryan Spain user avatar by
G. Ryan Spain
·
Oct. 10, 14 · Interview
Like (0)
Save
Tweet
Share
8.57K Views

Join the DZone community and get the full member experience.

Join For Free

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 .

SQLite

Opinions expressed by DZone contributors are their own.

Trending

  • You’ve Got Mail… and It’s a SPAM!
  • Boosting Application Performance With MicroStream and Redis Integration
  • Mainframe Development for the "No Mainframe" Generation
  • Application Architecture Design Principles

Comments

Partner Resources

X

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 600 Park Offices Drive
  • Suite 300
  • Durham, NC 27709
  • support@dzone.com

Let's be friends: