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 _______________________________________________ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
