2010/1/20 Brett Henderson <[email protected]>: 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 _______________________________________________ osmosis-dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/osmosis-dev
