[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