diff options
| author | Martin Tournoij <martin@arp242.net> | 2020-12-26 22:05:20 +0800 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-12-26 23:05:20 +0900 |
| commit | 02ce7ec581e490449391d2d17087ec41d169b0a4 (patch) | |
| tree | b72b2afd79ae7f729350644351d0a221dbb29707 /README.md | |
| parent | clarify usleep license (#893) (diff) | |
| download | golite-02ce7ec581e490449391d2d17087ec41d169b0a4.tar.gz golite-02ce7ec581e490449391d2d17087ec41d169b0a4.tar.xz | |
Add ?_cache_size=[..] to connection parameters (#894)
Add a shortcut for PRAGMA cache_size; this is a pretty useful setting:
the default of -2000 (2M) is not especially high, and a lot of people
will probably want to increase this.
For example, while running a bunch of fairy expensive queries in
parallel:
With SetMaxOpenConns(1):
-2000: 5762ms
-20000: 4714ms
With SetMaxOpenConns(20):
-2000: 3067ms
-20000: 2532ms
Which isn't a bad performance boost for changing a single number.
Diffstat (limited to 'README.md')
| -rw-r--r-- | README.md | 2 |
1 files changed, 2 insertions, 0 deletions
@@ -125,6 +125,8 @@ Boolean values can be one of: | Time Zone Location | `_loc` | auto | Specify location of time format. | | Transaction Lock | `_txlock` | <ul><li>immediate</li><li>deferred</li><li>exclusive</li></ul> | Specify locking behavior for transactions. | | Writable Schema | `_writable_schema` | `Boolean` | When this pragma is on, the SQLITE_MASTER tables in which database can be changed using ordinary UPDATE, INSERT, and DELETE statements. Warning: misuse of this pragma can easily result in a corrupt database file. | +| Cache Size | `_cache_size` | `int` | Maximum cache size; default is 2000K (2M). See [PRAGMA cache_size](https://sqlite.org/pragma.html#pragma_cache_size) | + ## DSN Examples |