[OSM-dev] Slow Osmosis

[Andreas Kalsch]

What I will try now:

1) combine("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

", "It scales always bad; no exceptions. Some advise on the DB techies 
even include to drop any primary and foreign keys (including sequences) 
at inserting. That is optimal.


Stefan", "If you are at it, and have a multi processor:

http://compression.ca/pbzip2/


Stefan")


If this is still slow, I will try

2) the raw file approach


Thank you for your help! I will send you the results.

Andi