Recommend this page to a friend! | Stumble It! | Bookmark in del.icio.us |
All requests | > | What is the best PHP mysql stored procedure class? | > | Request new recommendation | > | Featured requests | > | No recommendations | ||
by madhiyalagan - 1 year ago (2015-02-10) mysql stored procedure
+1 | I am new to using the stored procedures with PHP. I am fetching 10 Lakhs recordset using MySQL query so its taking long time to get the result set. If i use a stored procedure it will return the result set much faster then normal query. So please can you help me how to integrate MySQL stored procedure with PHP? |
0 | by Manuel Lemos 11100 - 1 year ago (2015-02-10) Comment If a query is taking too long to execute, using stored procedures just by itself may not make the query execute faster. You are probably noy using the appropriate indexes in the queries you are executing. Anyway, this class can help you to call MySQL stored procedures in PHP. |
1. by Gerry Danen - 1 year ago (2015-02-11) Reply
I agree, Manuel. Optimizing indexes, and proper joins go a long way to speeding up queries.
I found that in some cases, I just needed to do a "basic/foundation" query first, and then get additional detail later if the user wanted to drill down.
Hope that makes sense.
Recommend package | |
|