[MapProxy] repack tiles to sqlite

[Tobias Wendorff]

Hi there,

Am Fr, 23.09.2016, 11:23 schrieb Holger Schiebold:
>
> the improvements are wal mode, bulk storing and configurable timeout for
> the connect to prevent the database locked errors with high concurrency
> - is that right? Is it planned for next version of mapproxy? Defining an
> PRAGMA cache_size more then default is also faster here on my system.

Sorry, but this doesn't seem to be activated in dev build. I'm getting
lockups after some seconds. I've tried it on two different systems.

Creating sqlite tiles is veeeery slow. For the German "Ruhrgebiet",
seeding all tiles in filesystem takes about 25 minutes (zoom 0-22).
With sqlite it takes about 4 hours. All cores are at 10-20 % maxium,
while they're at 100% when rendering into files directly.

> @Tobias - for Migration of our old filesystem caches to sqlite for
> mapproxy we made a little script - it was much faster then using
> mapproxy-util export with the very little extension to make sqlite
> available there (thanks to Oliver for the hint)

I don't think it's FOSS, is it? ;)
I'm too busy to write my own tool right now :(

Best regards,
Tobias