diff options
| author |  Joey Hess <joeyh@joeyh.name> | 2015-02-15 14:29:27 -0400 |
|---|---|---|
| committer | Joey Hess <joeyh@joeyh.name> | 2015-02-15 14:29:27 -0400 |
| commit | cfda6d7dc457e501ba0c8cfc52b04693ad71ec74 (patch) | |
| tree | 98ca637586378e0bde215df50d8dd43043e67249 /doc/design/caching_database.mdwn | |
| parent | 7644cfac07de00f1d298b01d1a9d62fc9587f295 (diff) | |
update
Diffstat (limited to 'doc/design/caching_database.mdwn')
| -rw-r--r-- | doc/design/caching_database.mdwn | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/doc/design/caching_database.mdwn b/doc/design/caching_database.mdwn index 7fd5f37eb..5d84a091d 100644 --- a/doc/design/caching_database.mdwn +++ b/doc/design/caching_database.mdwn @@ -123,6 +123,11 @@ eg, esquelito. Update2: Using esquelito to do a join got this down to 0.109s. See `database` branch for code. +Update3: Converting to a single un-normalized table for AssociatedFiles +avoids the join, and increased lookup speed to 0.087s. Of course, when +a key has multiple associated files, this will use more disk space, due +to not normalizing the key. + Compare the above with 1000 calls to `associatedFiles`, which is approximately as fast as just opening and reading 1000 files, so will take well under 0.05s with a **cold** cache. |