[MapProxy] SQLite limits

[Fernando Ribeiro]

Hi again Oliver,

Uh, yeah. It should be possible to manually partition the data with the
> features of MapProxy if you only need WMS services. But I don't suggest
> to do that :)


I know you warned me, but I am lacking time for some answers on SQLite
changes... :)
So I did partition my data manually using WMS source features, by "cutting
of" several sources (the same request) by resolution levels. Additionally I
have set the equivalent number of caches, also "cutting of" cache
properties with the property "*use_direct_from_res*" to match sources
resolutions (some kind of cascading).
Now I have 5DBs SQLite and tested requests for the resolution different
levels (11) and everything seems ok. Tiles are saved where they should be.
Also seeding task seems ok, despite it seems to take a little longer, as
now it needs to seed 5 different caches.

My question is: Do you feel this approach maybe not be advisable as it can
have some drawback with a large amount of data (2Tb).

Cheers!

2011/11/8 Oliver Tonnhofer <olt at omniscale.de>

>
> On 07.11.2011, at 19:56, Fernando Ribeiro wrote:
> > On the other hand, of course we don't want the full 2Tb of data in a
> single database... we are thinking on a db "switch" scenario for some given
> zoom values and on minor scales by regions, as MapProxy deals great with
> these features...but this is only a scenario
>
> Uh, yeah. It should be possible to manually partition the data with the
> features of MapProxy if you only need WMS services. But I don't suggest to
> do that :)
>
>
> > Another question;
> > Is it safe to install your PIL modification package side-by-side with
> the "official" PIL package? Should I uninstall it first?
>
> Pip/easy_install should overwrite/update your existing PIL installation.
> You can run both versions in different virtualenvs if you have to. I would
> uninstall PIL if you have installed it as a system package from your
> distribution.
>
> Regards,
> Oliver
>
> --
> Oliver Tonnhofer    | Omniscale GmbH & Co KG    | http://omniscale.de
> http://mapproxy.org | https://bitbucket.org/olt | @oltonn
>
>
>
>
>


-- 
Fernando Ribeiro
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapproxy/attachments/20111110/4897023e/attachment.html