Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Which is faster, C & MySql or PHP & MySql?

I need to perform 3 million inserts to the database (mysql). PHP seems to be slow when it comes to insertion. I just need to verify if C performs faster in executing codes.

like image 627
Mark Cruz Avatar asked Dec 21 '22 12:12

Mark Cruz


1 Answers

The bottleneck is probably the database regardless of programming language.

You should look into batch inserts and disabling of indexes during insert to speed up the process.

like image 86
jishi Avatar answered Dec 24 '22 02:12

jishi