Mysql stored procedure parallel processing
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.
Subject
Views
Written By
Posted
Mysql stored procedure parallel processing
4585
January 07, 2016 08:50PM
1870
January 07, 2016 11:02PM
1169
January 09, 2016 11:41PM
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.