MySQL Forums
Forum List  »  Performance

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
623
August 23, 2016 11:29AM
357
August 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.