Re: Multi INSERT Command

[Francisco Alberto Tirado Zavala]

Hello Roberto.

The insertion speed depends of many factors like the size of the table, the indexes and others, it could be difficult to determine an average speed because the environments can be very different.

You can get more information about insertion speed here:
http://dev.mysql.com/doc/refman/5.0/en/insert-speed.html

And the insert size limit depends of the amount of available memory and the size of the communications buffer, you can take as reference the Text and Blob types, and you can find more info about it here:
http://dev.mysql.com/doc/refman/5.0/en/blob.html

Thanks for your time.

*** My opinions do not necessarily reflect the opinions of my employeer ***
MySql Windows Experience Team