SQLite Booster

Categories

Component ID

2143827

Component name

SQLite Booster

Component type

module

Maintenance status

Development status

Component security advisory coverage

covered

Downloads

822

Component created

Component changed

Component body

This module can speed up any drupal installation that uses the SQLite database driver. It has no effect on other database drivers so if you migrate databases and forget this module, nothing will happen.

Usage

You can just enable and forget this module.

Background

The speedup is done by wrapping the whole request in one transaction, so the database file will only be written once. Of course this blocks the database for the whole request, but SQLite is not suitable for several concurrent requests anyway.

Benchmarks

I experienced Speedups between 30% (60ms -> 40ms for a simple page) and 250% (3600ms -> 1300ms for cache clear). Feedback and other benchmarks are appreciated in the issue queue.