|All requests||>||What is the best PHP mysql stored pro...||>||Request new recommendation||>||Featured requests||>||No recommendations|
by madhiyalagan - 6 years ago (2015-02-10)
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?
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 - 6 years 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.