MySQL Forums :: Performance :: MySQL Table Valued Parameter
MySQL Table Valued Parameter
Posted by: tony mendoza ()
Date: August 23, 2016 11:29AM
We have a web app that parses xml and calls an insert stored procedure for each row (RBAR GRRRRR!!!!)... As you can tell this is performs poorly... In MSSQL I can create a table type for the front end devs to use or have them pass in a table input parameter. This lowers the stored procedure calls down to 1 opposed to many with the RBAR approach... Does anyone have any good ways for MySQL to handle this problem?
|MySQL Table Valued Parameter||518||tony mendoza||08/23/2016 11:29AM|
|Re: MySQL Table Valued Parameter||291||Rick James||08/26/2016 02:17PM|
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.