[OSM-dev] Slow Osmosis

[Stefan de Konink]

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