MySQL Forums
Forum List  »  Stored Procedures

Mysql stored procedure parallel processing
Posted by: kishorre venkkates
Date: January 07, 2016 08:50PM

can we call stored procedures in parallel way to increase execution speed. for eg: I have three stored procedures to extract data from three master tables and load/insert it into the single source table.Currently i am having three procedures :

CALL sp_1();
CALL sp_2();
CALL sp_3();
and running it in a sequential way to insert the records which takes more time. Is there any way to run all these procedures in parallel way to improve execution time and speed up the process..Kindly help me with a possible work around for this.

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql stored procedure parallel processing
3791
January 07, 2016 08:50PM


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.