[Tilesathome] t at h server performance

[Martijn van Oosterhout]

On Dec 23, 2007 7:21 PM, D Tucny <d at tucny.com> wrote:
> On 23/12/2007, Martijn van Oosterhout <kleptog at gmail.com> wrote:
> > The whole point of the exercise is to not store all those. Doesn't
> > really matter how, just need to find a way.
>
>  With 18 zoom levels (0-17) and a single layer, we get a total of approx 23
> billion tiles... If all we are going to store all of them as land or sea,
> the most efficient (storage wise, not speed wise and ignoring compression)
> way we could store them would be a single set of sequential bits, that would
> come out as about 2.7GiB...

You need at least three states, (LAND/SEA/TILE) so I'd suggest you
look at the code supporting the oceantiles_12.dat file which does
exactly this. Not everybody likes it though. An SQL table has the huge
advantage of being easily accessable with standard tools...

Have a nice day,
-- 
Martijn van Oosterhout <kleptog at gmail.com> http://svana.org/kleptog/