[OSM-dev] Further Database optimisation and data size

SteveC steve at asklater.com
Thu Apr 20 19:09:59 BST 2006


* @ 20/04/06 05:30:58 PM ge at gabrielebner.at wrote:
> On Thu, Apr 20, 2006 at 07:03:11PM +0100, Nick Hill wrote:
> > It seems the data is currently stored in double precision floating point.
> > This takes 8 bytes of data for each axis of the co-ordinate making 16 bytes
> > of 2d positional data for each point.
> 
> This makes 738451*16 bytes, which is just over 11M for all the nodes.  Would
> reducing the size by 5M be worth it?

me thinks not, given that youd be converting back and forth all the time
and we arn't running out of space. Becomes more interesting if we can
fit everything in memory and so on though.

have fun,

SteveC steve at asklater.com http://www.asklater.com/steve/




More information about the dev mailing list