Joachim Zobel wrote: > 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.
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 _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
