24.01.2014, 18:10
The server isn't frozen when using mysql_function_query.
This is instant as well as the server starts as fast as without using MySQL.
Only the queries take so much time to be processed in the background.
To time it right (waiting until queries are actually executed), I used mysql_query instead.
Try your same code this way (with your 1 million queries):
- start server
- end server immediately using CTRL C on the console window
You'll see it takes a while to shutdown as the queries are still being processed in the background.
Empty your database first so the data can be inserted.
I'll try updating the database with the same values when the data is already in place to see how long that takes.
So the UPDATE queries should overwrite all data instead of adding it.
This is instant as well as the server starts as fast as without using MySQL.
Only the queries take so much time to be processed in the background.
To time it right (waiting until queries are actually executed), I used mysql_query instead.
Try your same code this way (with your 1 million queries):
- start server
- end server immediately using CTRL C on the console window
You'll see it takes a while to shutdown as the queries are still being processed in the background.
Empty your database first so the data can be inserted.
I'll try updating the database with the same values when the data is already in place to see how long that takes.
So the UPDATE queries should overwrite all data instead of adding it.