[OSM-dev] Faster loading with scabies

[Noel Grandin]

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