Stored Procedures vs mysqli_multi_query
| From: | Iulian Manea | Date: | Fri, 20 Oct 2006 12:41:24 +0000 |
| Subject: | Stored Procedures vs mysqli_multi_query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-42581@lists.php.net to get a copy of this message | ||
Hey everybody,
Here is my problem: i have to exectute multiple SELECT queries to the
database, ad my question is how it would be how it would be faster:
1) either calling a stored procedure with mysqli_multi_query. That
stored procedure wold contain all of the SELECT queries.
2) using mysqli_multi_query to query all of the SELECTs directly
I don't know exactly how mysqli_multi_query works, i mena does it send
all of the queryes in one message to the mysql server, or one by one
(like a regulat mysql(i)_query)? Because if you call a stored procedure
it sends just ONE query (the CALL of the procedure).
I hope you understood what i ment ...
Thanks in advance!