Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Should store procedures be cached in MySQL? If so, How long it is stay in cache?

In my case, When I call one stored procedure first time, it is giving me results in 1 second, after that it gives me result in 400ms. And when I am changing some parameters passed to stored procedure, I see the same behavior. So, I can not understand what is happening?

share|improve this question
    
Please don't cross-post, this scatters potential answers around. If you think you picked the wrong site when you posted, flag it for moderator attention and ask for a migration to another site. –  Mat May 10 '13 at 9:07
    
sorry for this. It is done by mistek –  Manish Sapkal May 10 '13 at 13:50

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.