OK, I will create the tables as InnoDB tables directly, this is surely better ;)
Joachim Zobel schrieb: "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." > "Be aware that an ALTER TABLE on MySQL (at least with InnoDb) always > copies the table into the new strucure. If you do an ALTER TABLE ... > ENGINE=InnoDb this is unavoidable. All other ALTER TABLE statements are > questionable." > _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
