PHP Classes

What is the best PHP mysql stored procedure class?: Using stored procedures in MySQL application with PHP

Recommend this page to a friend!
  All requests RSS feed  >  What is the best PHP mysql stored pro...  >  Request new recommendation  >  A request is featured when there is no good recommended package on the site when it is posted. Featured requests  >  No recommendations No recommendations  

What is the best PHP mysql stored procedure class?


Picture of madhiyalagan by madhiyalagan - 8 years ago (2015-02-10)

Using stored procedures in MySQL application with PHP

This request is clear and relevant.
This request is not clear or is not relevant.


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?

Ask clarification

1 Recommendation

Lightweight MVC MySQL SP Class: Call MySQL stored procedures

This recommendation solves the problem.
This recommendation does not solve the problem.


Picture of Manuel Lemos by Manuel Lemos Reputation 23055 - 8 years 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 Comment
  • 1. Picture of Gerry Danen by Gerry Danen - 8 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.

Recommend package