Should store procedure cached in Mysql? If yes, How long it is stay in cache?
In my case, When I call one store procedure first time, It is giving me result in 1sec, after that it gives me result in 400ms. and when I am changing some parameters passed to store procedure and call first time, same behavior performed. So, I can not understand what happening? Can some one guide me?
Thanks.