Menu

#31 Store cache in a database

1.4
closed
None
closed
source
minor
1.2.4
feature
2014-07-23
2014-03-21
Bruce Merry
No

Using something like sqlite would have a number of advantages:
- One big file instead of hundreds of little files
- Easier to drop just old versions
- No need to mess about with md5 sums and base64 encoding
- Possibly easier to debug, since one can use command-line tools to query the cache
- On-the-fly tuning would become viable, since locking could be handled portably
- Potentially faster repeated lookups, if things are in the page cache

The obvious downside is an extra dependency.

There should probably be one table per (algorithm,version) pair since this will determine the schema.

Discussion

  • Bruce Merry

    Bruce Merry - 2014-07-23
    • Description has changed:

    Diff:

    --- old
    +++ new
    @@ -6,9 +6,7 @@
     \- On-the-fly tuning would become viable, since locking could be handled portably  
     \- Potentially faster repeated lookups, if things are in the page cache  
    
    -
     The obvious downside is an extra dependency.  
    -
    
     There should probably be one table per (algorithm,version) pair since this will determine the schema.  
    
    • Milestone: --> 1.4
    • Resolution: --> new
     
  • Bruce Merry

    Bruce Merry - 2014-07-23
    • Status: new --> closed
    • Resolution: new --> closed