optimering - insert into
Hej drengene.Jeg sidder og læser om databaseoptimering og er faldet over følgende uddrag:
"If you are inserting many rows from the same client at the same time, use INSERT statements with multiple VALUES lists to insert several rows at a time. This is much faster (many times faster in some cases) than using separate single-row INSERT statements.
¨
If you are adding data to a non-empty table, you may tune the bulk_insert_buffer_size variable to make it even faster. See Section 4.2.3, "Server System Variables.""
Jeg forstår dog ikke helt hvad de mener med disse to eksempler. Er der nogen der kan forklare dette?
