Multiple runNamedQueries or Stored Procedure?

If I need to run +3 runNamedQueries in a row for a single operation, is it more efficient to just create a stored procedure and call it once to handle all the of the queries? I’ve only used a stored procedure call once in Igntion, and IIRC it is kind of verbose to make the call. Thoughts?

I only save a 10-20ms using a stored procedure. Indexing may cause varied results.

Sorry 3 year old post, was trying to find out how to handle a runNamedQuery result that didn't have a parameter match when I saw this.
Figured it out, I check the data.rowCount<1.

1 Like