35% Faster Than The Filesystem
35% Faster Than The Filesystem
1. Summary
SQLite reads and writes small blobs (for example, thumbnail images)
35% fasterĀ¹ than the same blobs
can be read from or written to individual files on disk using
fread() or fwrite().
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
working from an SQLite database, the open() and close() system calls
are inv...
Read more at sqlite.org