[Tiling] Steps towards a better filemanagement

[Oliver Tonnhofer]

Hi list, hi Steven,

On 11.04.2011, at 10:32, Steven M. Ottens wrote:
> Last week I met Oliver Tonnhofer at FOSSGIS in Germany. We discussed the problems of tiling and especially tile-cache-management. My immediate problems are too many files to manage (for instance backups), updating of tiles, smart seeding (seeding the most popular regions first).
> He said that he already had done some benchmarks on SQLite and it appears to be fast enough to serve tiles. So our idea is to use SQLite as a tilestore. Storing both the tiles and its metadata. Most likely using one database per tilecache-layer or maybe one database per tilecache-layer and zoomlevel.

Yes, we developed an SQLite based prototype (simple table with x, y, z, blob) and the numbers where quite comparable with the file system based tile backend (tilecache schema). I'll post the numbers here in the next days.

I've also started to design a database schema for a new tile store format that supports multiple caches per database and also caches split into multiple databases. I'll write that all up and post it here for discussion.


Regards,
Oliver

-- 
Oliver Tonnhofer    | Omniscale GmbH & Co KG    | http://omniscale.de
http://mapproxy.org | https://bitbucket.org/olt | @oltonn