MySQL Forums
Forum List  »  Knowledge Base

Stored Procedure Very Slow - Help!
Posted by: Leo Severian
Date: August 02, 2009 01:11PM

Please help!!! I have a mysql application that uses a stored procedure to update a table:
> update table_A inner join view_B on table_A.fld = view_B.fld set table_A.fld2 = view_B.fld2.
The first call to the procedure runs fine(1.73 seconds) but subsequent calls take over 2 MINUTES!!! for the same connection. Using a new connection will once again allow the first call to run fine and any subsequent calls to run slow.
Running the query outside of the procedure works fine.

Any ideas?

Options: ReplyQuote

Written By
Stored Procedure Very Slow - Help!
August 02, 2009 01:11PM
September 02, 2009 01:43PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.