diff options
| author |  Joey Hess <joeyh@joeyh.name> | 2015-02-22 14:49:05 -0400 |
|---|---|---|
| committer | Joey Hess <joeyh@joeyh.name> | 2015-02-22 14:49:05 -0400 |
| commit | ea0a4c8be825fa020f89886367acd00a18cc0677 (patch) | |
| tree | cbb1eeb668da7ba684dcd6a31bf9218534e5035f /doc/design | |
| parent | 3fe6936c8b0882644655a5e4044c55798b8fbddb (diff) | |
update with benchmarks for fsck -- sqlite added only 10s
Diffstat (limited to 'doc/design')
| -rw-r--r-- | doc/design/caching_database.mdwn | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/doc/design/caching_database.mdwn b/doc/design/caching_database.mdwn index 8678f8c3d..c61dd4852 100644 --- a/doc/design/caching_database.mdwn +++ b/doc/design/caching_database.mdwn @@ -25,7 +25,7 @@ Store in the database the Ref of the branch that was used to construct it. ## implementation plan -1. Store incremental fsck info in db, on a branch, with sqlite. +1. Store incremental fsck info in db, on a branch, with sqlite. **done** 2. Make sure that builds on all platforms. 3. Implement for metadata, on a branch, with sqlite. 4. Add associated file mappings support. This is needed to fully @@ -148,3 +148,9 @@ perform better when adding an associated file to a key that already has many. For metadata, the story is much nicer. Querying for 30000 keys that all have a particular tag in their metadata takes 0.65s. So fast enough to be used in views. + +Update4: Comparing git-annex fsck using the sticky bit to the final sqlite +implementation: + +sticky bit: 4m30.787s +sqlite: 4m40.789s |