fn!executestoredprocedure plug-in versus execute stored procedure node performance

Hi,

We currently have an application that calls a stored procedure on an Oracle db using the execute stored procedure node. We have Multiple Instances of this node running to validate data that is entered into a grid. There could be over 100 rows in the grid, and the execute stored procedure node is run for each row. Each time the node is run, it takes .1 to .2 seconds to complete. Instead of running multiple instances of this node to call the stored procedure, I thought I would try to call the fn!exectuestoredprocedure within the sail form, within an a!foreach loop. I tried calling the stored procedure this way for just 2 rows, I checked  the performance and it's taking about 8.5 seconds to complete the fn!executestoredprocedure call. That is a big difference in performance. Does anyone know if there is anyway to improve performance using the plug-in versus the delivered execute stored procedure node? 

Thanks for your help.

  Discussion posts and replies are publicly visible