[MapProxy] best caching system

[Rahkonen Jukka (Tike)]

Hi,


I do not know if Mapproxy is already utilizing thishttp://www.sqlite.org/wal.html


If not it feels like your use case would be something that could have use for WAL. Let's wait what the developers say.


-Jukka Rahkonen-

________________________________
Jeff Konnen wrote:

Hi,

what is the best option for keeping a cache of a layer in the filesystem?

I've used sqlite because of the benefits of the database (vs filesystem) and the ability to use refresh_before seeds..

But when seeding, I keep running into the following fatal error: sqlite3.OperationalError: database is locked

Is there anything I could do here? Is is because of the concurrency of the seeding (and the on-the-fly rendering) ?

While the file cache fills up my inodes very fast, I don't have these locking problems..

What's the ideal solution for a layer that has to be reseeded once a week but continuously online?

Best regards
Jeff

--
Jeff Konnen
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapproxy/attachments/20141029/02f1eee1/attachment.html>