[osmosis-dev] populateCurrentTables=no

[Simon Nuttall]

2010/1/20 Brett Henderson <brett at bretth.com>:
8<
> You could possibly add populateCurrentTables=no to the --write-apidb task
> and use the history tables for your queries.  After a planet import they
> contain identical data to the current tables.  Are the history tables still
> MyISAM or are they InnoDB?  I haven't used MySQL for a while.  If the
> history tables are MyISAM and you disable current table population you
> should get very large performance speedups.

Following your suggestions I modified all the tables to MyISAM and
switched the CycleStreets import code to reading only the history
tables.

Now, instead of 17.3 hours it is takes only 2.8 hours on the slow
machine, and just less than an hour on our main machine.

This is back to the sort of timings we had a year ago when the data
was much smaller and when we only covered great britain.

Thank you and I'm really glad I asked.


Simon