MySQL Forums :: Performance :: MySQL Table Valued Parameter


Advanced Search

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?

Thanks

Options: ReplyQuote


Subject Views Written By Posted
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.