Documentation Source Text

Check-in [2912902889]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Fix typo and clarify wording in the new faster-than-filesystem update.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 2912902889f80e4e1daaa1b35a617e2bc73e48ecb48d74f418024f0df37ff802
User & Date: drh 2017-05-22 20:01:48.130
Context
2017-05-22
20:04
Another typo in the faster than filesystem document. (check-in: de15ebf872 user: drh tags: trunk)
20:01
Fix typo and clarify wording in the new faster-than-filesystem update. (check-in: 2912902889 user: drh tags: trunk)
19:38
Fix another release note typo. (check-in: 4020461a82 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/fasterthanfs.in.
︙︙
170
171
172
173
174
175
176
177

178
179
180
181
182
183
184


<p>The table below shows data collected using 
[https://www.sqlite.org/src/file/test/kvtest.c|kvtest.c] on five different
systems:  An old Dell laptop running Windows7, a new Lenovo laptop running
Windows10, a Mac-Pro, an Ubuntu desktop machine, and an older Android
phone (a Galaxy S3). All machines use SSD except the Dell which has a
hard-drive. The test database is 100K BLOBs uniformly
distributed between 8K and 12K in size, each.  The database page size

is 4KiB.  The chart shows average BLOB access time in microseconds.

<center>
<table border=1>
<tr>
<th>kvtest arguments
<th>Win7








|
>








170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185


<p>The table below shows data collected using 
[https://www.sqlite.org/src/file/test/kvtest.c|kvtest.c] on five different
systems:  An old Dell laptop running Windows7, a new Lenovo laptop running
Windows10, a Mac-Pro, an Ubuntu desktop machine, and an older Android
phone (a Galaxy S3). All machines use SSD except the Dell which has a
hard-drive. The test database is 100K BLOBs uniformly
distributed between 8K and 12K in size, for a total about 1 gigabyte
of content.  The database page size
is 4KiB.  The chart shows average BLOB access time in microseconds.

<center>
<table border=1>
<tr>
<th>kvtest arguments
<th>Win7
︙︙
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229

Always remember:  <i>Your mileage may vary</i>.
Rerun these tests yourself on your own hardware using data that is
a close match to your production data before drawing conclusions.

<p>
Notice that the individual file access times on Windows are dramatically
slower than on the unix systems.  This might be because the 100K BLOBs are
all stored ina single directory and Windows is inefficient at searching
directories with large numbers of files.  The Windows file access times
might be improved if the BLOBs were stored in a hierarchy of directories,
rather than dumping them all into a single big directory.

<h2>Key Points</h2>

<ol>








|








216
217
218
219
220
221
222
223
224
225
226
227
228
229
230

Always remember:  <i>Your mileage may vary</i>.
Rerun these tests yourself on your own hardware using data that is
a close match to your production data before drawing conclusions.

<p>
Notice that the individual file access times on Windows are dramatically
slower than on the unix systems.  This might be because the 100K BLOBs are
all stored in a single directory and Windows is inefficient at searching
directories with large numbers of files.  The Windows file access times
might be improved if the BLOBs were stored in a hierarchy of directories,
rather than dumping them all into a single big directory.

<h2>Key Points</h2>

<ol>
︙︙