Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix a typo in intern-v-extern-blob.html |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
c8b280b8eb0389b3c888403c50a7a6c9 |
| User & Date: | drh 2013-05-01 00:14:55 |
Context
|
2013-05-01
| ||
| 11:02 | Fix typos in queryplanner-ng.html. check-in: c9e2b500a2 user: drh tags: trunk | |
| 00:14 | Fix a typo in intern-v-extern-blob.html check-in: c8b280b8eb user: drh tags: trunk | |
|
2013-04-30
| ||
| 22:20 | Updates to the next-generation-query-planner document. check-in: 28554e7596 user: drh tags: trunk | |
Changes
Changes to pages/intern-v-extern-blob.in.
8 8 If you have a database of large BLOBs, do you get better read performance 9 9 when you store the complete 10 10 BLOB content directly in the database or is it faster to store each BLOB 11 11 in a separate file and store just the corresponding filename in the database? 12 12 </p> 13 13 14 14 <p> 15 -To try answer this, we ran 49 test cases with various BLOB sizes and 15 +To try to answer this, we ran 49 test cases with various BLOB sizes and 16 16 SQLite page sizes on a Linux workstation (Ubuntu circa 2011 with the 17 17 Ext4 filesystem on a fast SATA disk). 18 18 For each test case, a database was created that contains 100MB of BLOB 19 19 content. The sizes of the BLOBs ranged from 10KB to 1MB. The number 20 20 of BLOBs varied in order to keep the total BLOB content at about 100MB. 21 21 (Hence, 100 BLOBs for the 1MB size and 10000 BLOBs for the 10K size and 22 22 so forth.) SQLite version 3.7.8 was used.