35% Faster Than The Filesystem

35% Faster Than The Filesystem

1. Summary

Small blobs (for example, thumbnail images) can be read out of an SQLite database about 35% faster than they can be read from individual files on disk.

Furthermore, a single SQLite database holding 10-kilobyte blobs uses about 20% less disk space than storing the blobs in individual files.

The performance difference arises (we believe) because when reading from an SQLite database, the open() and close() system calls are invoked only once, whereas open() and close() are