[Tilesathome] www down?

Robert (Jamie) Munro rjmunro at arjam.net
Sat May 26 13:05:03 BST 2007


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

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.

But that performance penalty may be more than offset by the fact that
more of the database will fit into caches etc.


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

iD8DBQFGWCJrz+aYVHdncI0RAjP9AKDIKdeGSXW3dI6mLimUcCu61vCepACgzYK6
CALWMOntPQ7jKeTi1rjRE7s=
=Q2Yz
-----END PGP SIGNATURE-----




More information about the Tilesathome mailing list