Member Avatar for sathishnadu

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.

  • 2 Contributors
  • 1 Reply
  • 174 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by cereal
Member Avatar for cereal

There is no timeout for cache entries, the system works by deleting the least recently used (LRU algorithm), for more information check:

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

I don't understand, can you provide an example?

Edited by cereal
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.