July 15, 2008 at 12:33 MySQL Stored Procedures.
Hello. Often there are needs for recursive data processing, chaining, linking products to categories, and more.
If you use PHP + MySQL (while, foreach, for + mysql_query), processing a huge number of queries, the execution time of the script increases to 10-15 seconds, because There are a lot of requests, but it is almost impossible to reduce the number of requests.
Therefore, I would like to ask the MySQL guru how to build procedures (functions) in MySQL, maybe they will help me reduce the script execution time.
If you use PHP + MySQL (while, foreach, for + mysql_query), processing a huge number of queries, the execution time of the script increases to 10-15 seconds, because There are a lot of requests, but it is almost impossible to reduce the number of requests.
Therefore, I would like to ask the MySQL guru how to build procedures (functions) in MySQL, maybe they will help me reduce the script execution time.
The request follows from here:
Please tell me the links, and preferably the book, which describes this topic.