[OSM-dev] Can SQLite3 handle OSM 150G data file?

Christoph Eckert ce at christeck.de
Tue Apr 28 20:01:37 BST 2009


Hi,

> There is no reason to be sqlite slow. How much are you are using
> transactions on your local db? What are you using for import? I'm
> importing Czech republic (50Mb bziped) in one or two minutes. So for
> 5.4GB it takes 108 minutes (two hours). But I'm importig to modified osm
> schema (something like mapnik schema in postgress). It is because of
> query speed.

sounds cool. Is the Script that does the conversion from osm.xml into sqlite 
available somewhere?

Thanks & best regards,

ce




More information about the dev mailing list