diff options
author | 2015-02-22 19:48:10 -0400 | |
---|---|---|
committer | 2015-02-22 19:48:55 -0400 | |
commit | 6c8e7bce21fb3b286b3a776d57c81f93ed7a4b14 (patch) | |
tree | b9b792d6dca00cab791e04c9f2e8e6a43d98ea2e /doc/devblog/day_258__database_branch_merged.mdwn | |
parent | 532546a2ce903bf3eab918917e72b7ee8c20f2f2 (diff) |
devblog
Diffstat (limited to 'doc/devblog/day_258__database_branch_merged.mdwn')
-rw-r--r-- | doc/devblog/day_258__database_branch_merged.mdwn | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/doc/devblog/day_258__database_branch_merged.mdwn b/doc/devblog/day_258__database_branch_merged.mdwn new file mode 100644 index 000000000..97cae78b5 --- /dev/null +++ b/doc/devblog/day_258__database_branch_merged.mdwn @@ -0,0 +1,25 @@ +I'm snowed in, but keeping busy.. + +Developed a complete workaround for the [sqlite SELECT ErrorBusy bug](http://news.gmane.org/find-root.php?message_id=20150219163255.GA13383%40kitenet.net). +So after a week, I finally have sqlite working robustly. And, I merged in +the branch that uses sqlite for incremental fsck. + +Benchmarking an incremental fsck --fast run, checking 40 thousand files, +it used to take 4m30s using sticky bits, and using sqlite slowed it down by +10s. So one added second per 4 thousand or so files. I think that's ok. +Incremental fsck is intended to be used in big repos, which are probably not +checked in --fast most, so the checksumming of files will by far swamp +that overhead. + +Also got sqlite and persistent installed on all the autobuilders. This +was easier than expected, because persistent bundles its own copy of +sqlite. + +That would have been a good stopping place for the day's work.. But then I +got to spent 5 more hours getting the EvilSplicer to support Persistent. +Urgh. :-/ + +Now I can look forward to using sqlite for something more interesting than +incremental fsck, like metadata caching for views, or the direct mode mappings. +But, given all the trouble I had with sqlite, I'm going to put that off for +a little while, to make sure that I've really gotten sqlite to work robustly. |