optimization - Mysql - Stored procedure not using the query cache -

I have just changed a SQL Selection statement in a stored procedure

Use SQL Statement The selection takes the statement to run for the first time after 0.4784 and 0.0003

The stored procedure takes 0.4784 seconds to run each time.

I think the query cache has not been used

How can I improve it?

Select a simplified version of the code

  where the location = name =: venue  

====== =

  Get the manufacturing process (Venu Warkar (22)) from the select locations where the location = name = wenu end;  

Welcome to MySQL ... It is difficult to get anything stored in the stored procedure To take advantage of the query's cache, Dev Articles discusses this in some detail. Reference documents have also been mentioned on borders.

Actually, do not depend on caching of queries executed inside stored procedures. It is near impossible to work, though claims that this is possible. This is not usually a problem if you are using stored procedures to use complex logic. The problems I have seen are done using stored procedures for very simple questions, where there is ample amount.