diff options
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. |