On Feb 3, 2010, at 7:41 PM, JJZolx wrote: > > andyg;513405 Wrote: >> The cache is now in ArtworkCache.db. Hopefully that's the last time I >> change this. > > The cached images themselves are now in a database? As BLOBs, I > presume. In the context of a web server, I'd always heard that the > overhead of making the dbms insert and extracting the data made this > less efficient than working with individual files. That may have been > because some HTTP servers require the files to be written out to disk > first before they can be served. Are you able to serve these images > directly from the database, without writing them to disk at all?
Yep, as BLOBs. SQLite as a key/value cache turns out to be twice as fast as plain files, which I had tried to optimize as much as I could. It's 10x as fast as our old FileCache cache. Also you waste less disk space by not having a bunch of directories. Nothing needs to be written to the disk before serving the images. I already notice the speed difference in iPeng and SqueezePlay scrolling through the album list, the covers appear almost instantly. _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
