[OSM-dev] Slow Osmosis

Joachim Zobel jz-2008 at heute-morgen.de
Mon Dec 1 07:16:28 GMT 2008


Am Sonntag, den 30.11.2008, 21:38 +0100 schrieb Andreas Kalsch:
> I have split up the sql script in two parts - 1st to create table
> just 
> with primary keys on auto_increment fields, 2nd to alter the
> populated 
> 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.

Sincerely,
Joachim






More information about the dev mailing list