<div>
note: the above suggestion should be magnitues faster that inserting each row individually as bascially only 1 database call/transaction is involved instead of hundreds/thousands<br />
note: if there are many more, you will need to &quot;split&quot; into inserts of something like 1000-2000 rows at once maximum, otherwise you might reach some other limits.
</div>


note: the above suggestion should be magnitues faster that inserting each row individually as bascially only 1 database call/transaction is involved instead of hundreds/thousands
note: if there are many more, you will need to "split" into inserts of something like 1000-2000 rows at once maximum, otherwise you might reach some other limits.

<div>
<div class="content wysiwyg-content">
In a script I have written, I execute about 1000 inserts to the database. Currently I am using a for each statement and execute each insert one by one. It takes some time so I was wondering if there is a faster way to do this. For example I could be a query that runs all the queries together and run it in the end of the for each statement but I don't know if it would be faster.
</div>
</div>


In a script I have written, I execute about 1000 inserts to the database. Currently I am using a for each statement and execute each insert one by one. It takes some time so I was wondering if there is a faster way to do this. For example I could be a query that runs all the queries together and run it in the end of the for each statement but I don't know if it would be faster.

Inserting several records at once. Which is the best way?

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.