Stored Procedure Very Slow - Help!
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?
Subject
Views
Written By
Posted
Stored Procedure Very Slow - Help!
4310
August 02, 2009 01:11PM
2066
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.