How to use the same connection in PHP ,while accessing the Mysql SP(have cases in SP's)?and how to improve the performance of Database and Application ?
Hello,
Thank you for your question regarding mySQL. We are happy to assist you, but will need additional information to provide a meaningful answer.
I am not sure what you mean by SP's. Could you provide more information?
If you are following a guide or tutorial on SP's, can you provide a link to it?
Here is a helpful guide on how to Reduce database calls to improve website performance.
We also have a guide on Monitoring MySQL performance.
If you have any further questions, feel free to post them below.
Thank you,
John-Paul