Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Minor wording tweaks to the 35%-faster document. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA3-256: |
a1177bfca0985fbe848997a6a8e1522c |
User & Date: | drh 2017-05-10 16:38:21.975 |
Context
2017-05-11
| ||
13:36 | Fix the description of the SQLITE_READ authorizer change in the change log. (check-in: fd8d8bb382 user: drh tags: trunk) | |
2017-05-10
| ||
16:38 | Minor wording tweaks to the 35%-faster document. (check-in: a1177bfca0 user: drh tags: trunk) | |
16:34 | Add the SQLITE_READ authorizer change to the change log for 3.19.0. (check-in: 84e21ebf22 user: drh tags: trunk) | |
Changes
Changes to pages/fasterthanfs.in.
1 2 3 4 5 6 7 | <title>35% Faster Than The Filesystem</title> <tcl>hd_keywords {faster than the filesystem}</tcl> <table_of_contents> <h1>Summary</h1> | | | | | | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 | <title>35% Faster Than The Filesystem</title> <tcl>hd_keywords {faster than the filesystem}</tcl> <table_of_contents> <h1>Summary</h1> <p>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. <p>Furthermore, a single SQLite database holding 10-kilobyte blobs uses about 20% less disk space than storing the blobs in individual files. <p>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 invoked once for each blob when reading the blobs from individual files. It appears that the |
︙ | ︙ |