Single query or multiple queries

Question

I have a table having 4 columns and I need to insert over 5k rows. Is it good to insert them using 1 query, or each row having its separate query. The database is mysql.

Answer 1

I guess it would perform better if you insert them in one insert sentence. Keep in mind that this way, if one of the insertion fails, the whole insertion will fail. On the other hand, if you run in multiple sentences, if one insertion fails, the other insertions could continue with no problems. Unless you are running them in a single transaction context.