[Tilesathome] www down?

Sebastian Spaeth Sebastian at SSpaeth.de
Mon May 28 08:39:01 BST 2007


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Robert (Jamie) Munro wrote:
> Frederik Ramm wrote:
>> On levels 0-12 combined, we have a total of about 22 million tiles  
>> for the whole world, of which about 6.7 million will be land tiles.  
>> Now this is a figure one could deal with - 6.7 million rows of 50  
>> bytes each is about 350 Megabytes in an SQL table. If we employ  
>> strict recursion (i.e. "if a level-5 tile is fully on land, then do  
>> not store any of the tiles contained therein explicitly"), we can get  
>> that figure down from 6.7 million to a small six-digit figure (I  
>> computed it once but forgot the exact number), but that would of  
>> course mean a performance penalty when retrieving data.

Interesting data, thhanks. That performance hit might not be that big,
as those recursive lookups would happen in areas where there is only
blank land/sea around. So if you happen to scroll at z17 across the
pacific ocean (or the sibirian taiga) you have other problems than
slowness of retrieving z17 tiles. :-)

Spaetz
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGWocVbtVRNeSDtgERApcsAJ9D8YrbjhY1YZDLanUii819hYiZnwCfdHqp
wK6nWIgX0SaqMzjn0xJa65M=
=3dO/
-----END PGP SIGNATURE-----





More information about the Tilesathome mailing list