Inserting several records at once. Which is the best way?
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.