Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Update the speed and size graphs. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
c674dc0ada10966adcc4704d50080491 |
| User & Date: | drh 2017-10-24 14:54:42 |
Context
|
2017-10-24
| ||
| 18:26 | Add news for the 3.21.0 release. (check-in: 83687a0810 user: drh tags: trunk) | |
| 14:54 | Update the speed and size graphs. (check-in: c674dc0ada user: drh tags: trunk) | |
| 12:47 | Deprecate the SQLITE_RTREE_INT_ONLY compile-time option. (check-in: c0722042ac user: drh tags: trunk) | |
Changes
Changes to images/cpu-usage.jpg.
cannot compute difference between binary files
Changes to misc/speed-size-graph.ods.
cannot compute difference between binary files
Changes to pages/cpu.in.
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 |
<tcl>hd_keywords {CPU cycles used} {CPU performance measurement}</tcl>
<table_of_contents>
<h1>Overview</h1>
<p>The graph below shows the number of CPU cycles used by SQLite on a
standard workload, for all versions of SQLite going back about 5.5 years.
The number of CPU cycles used by SQLite has been
halved in just the past three years.
<p>
This article describes how the SQLite developers measure CPU usage,
what those measurements actually mean, and the techniques used by
SQLite developers on their continuing quest to further reduce the
CPU usage of the SQLite library.
</p>
<center>
<hr>
<div class="imgcontainer">
<img src="./images/cpu-usage.jpg"></img></div><br>
Measured using cachegrind on Ubuntu 16.04 on x64 with gcc 5.4.0 and -Os.<br>
Values normalized so that version 3.20.0 is 100%.
<hr>
</center>
<h1>Measuring Performance</h1>
<p>In brief, the CPU performance of SQLite is measured as follows:
|
| | | | |
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 |
<tcl>hd_keywords {CPU cycles used} {CPU performance measurement}</tcl>
<table_of_contents>
<h1>Overview</h1>
<p>The graph below shows the number of CPU cycles used by SQLite on a
standard workload, for all versions of SQLite going back about 9 years.
Recent version so SQLite use less then a third of the CPU cycles
compared to older versions.
<p>
This article describes how the SQLite developers measure CPU usage,
what those measurements actually mean, and the techniques used by
SQLite developers on their continuing quest to further reduce the
CPU usage of the SQLite library.
</p>
<center>
<hr>
<div class="imgcontainer">
<img src="./images/cpu-usage.jpg"></img></div><br>
Measured using cachegrind on Ubuntu 16.04 on x64 with gcc 5.4.0 and -Os.<br>
Values normalized so that version 3.21.0 is 100%.
<hr>
</center>
<h1>Measuring Performance</h1>
<p>In brief, the CPU performance of SQLite is measured as follows:
|