[OSM-dev] Faster loading with scabies
noel at peralex.com
Mon Oct 20 10:45:52 BST 2008
Most modern databases have some kind of "block-load" API for efficiently
importing large chunks of data into their tables.
It's really only the most simple stuff that __doesn't__ slow down when
importing using INSERT.
Although it should plateau to a constant time/INSERT pretty quickly.
Brett Henderson wrote:
>>> MyISAM tables are very fast to import regardless of number of rows,
>>> but InnoDB seems to slow down as the number of rows increase. I'm
>>> surprised loading with LOAD DATA INFILE fixes that.
>> LDI is probably the fastes way to get data into mysql.
More information about the dev