Execute multiple insert, update, queries separated by ";" at once!

Question

I use remote server to store values into MySQL database.

I don't use any SELECT queries, only INSERT, DELETE and UPDATE.

When I execute 70,000 queries I have trouble with speed.

I was trying mysql_unbuffered_query and I saw little performance profit but it's still too slow.

I remember that some functions in PHP allow me to execute several lines, separated by ;

$something=<<<something

query1 ;
query2 ;
query3 ;

something;

execute($something)

Can someone can help me remember ?

Maybe in PDO ?

Answer 1

The feature you are thinking of is the PHP heredoc syntax. It allows you to do multiple line strings using <<<.

But PDO does not support multiple SQL statements at once. You need to split them up and execute each one individually. You said this was too slow for you, so you may not be able to use PDO.

If you have many statements that are the same but with different parameters, you can use PDO prepared statements. With these, you can prepare the statement once, then just execute it with different parameters. If you have multiples types of statements, you will need to prepare each individually. You can read more about prepared statements here. They also have the benefit of not being vulnerable to SQL injection.