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 _______________________________________________ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev