CODEWITHSUNDEEP
phpmysqlmysqli
kumar Soneta
kumar Soneta

Reputation: 21

Does Mysqli_multi_query improve performance

I am updating mysql data through php script. I am looking to use mysqli_multi_query() instead of mysql_query. I have N number of update queries to execute. Please suggest if multi query will help in better execution time.

A. Updating data using mysql_query(), Firing single single queries N times.
B. Concatinating All Update queries with ";" and firing once using multi query.

Please Suggest if Technique "B" will help in performance.

Thanks.

Upvotes: 1

Views: 1032

Answers (1)

Gervs
Gervs

Reputation: 1397

C. Use prepared statements and if possible (InnoDB) within a transaction.

A multiquery will save you some client-server roundups, but the queries are still executed one by one.

If you use prepared statement together with transactions, the query is checked once by the parser after that just values are pasted to server. Transaction prevents indexes being rebuild after each update.

Multiple insert statements can be rewritten as a single bulk insert statement:

INSERT INTO t1 (c1,c2,c3) VALUES (1,2,3), (3,4,5) --etc

Upvotes: 1

Related Questions