[OSM-dev] Faster loading with scabies

Noel Grandin 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:
> Joac
>>> 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. 

Disclaimer: http://www.peralex.com/disclaimer.html

More information about the dev mailing list