Thanks to everyone who replied. OK, loading all the nodes for OSM doesn't take much time, but INDEXing the fields takes forever (days).
The first time I tried this, I pre-created the indexes before loading the data. That's why the load took so long. This time, I loaded the data first (fairly quick) and then created the indexes. It's now been several days and the indexes are still being created. Thoughts? -- We're just a Bunch Of Regular Guys, a collective group that's trying to understand and assimilate technology. We feel that resistance to new ideas and technology is unwise and ultimately futile. On 4/27/09, Kelly Jones <[email protected]> wrote: > I've seen many posts saying that SQLite2 can't handle OpenStreetMap's > large planet.osm data file: > > http://planet.openstreetmap.org/planet-090421.osm.bz2 > > which is 5.4G bzip2 compressed, about 150G uncompressed. > > Can SQLite3 handle this? Has anyone tried? > > I tried to do this myself, but I'm on a slow machine and it's taking > too long (several days so far). If someone's done this, can I get a copy? _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
