[OSM-dev] Slow Osmosis

[Joachim Zobel]

Am Samstag, den 29.11.2008, 18:45 +0100 schrieb Andreas Kalsch:
> I decompress the data before putting them into Osmosis, but it's still
> slow.
> So back to my question -- ;)
> (The best would be raw dump files for MySQL's "LOAD DATA INFILE" - I
> can 
> imagine that it would be pretty quick)

There is another approach. ALTER all InnoDb tables to MyISAM, run
osmosis and then ALTER them back to InnoDb. 

It seems that the INSERT approach scales badly to large InnoDb tables.

Sincerely,
Joachim