Unanswered: nested sql stored procedure performance problem
Is there any problem with nested sql stored procedures?
I have big problem with it cause our application based on it and on informix & sql server on the same hardware it works 4-6 times faster.
There are lot of nested sp in it and level of nesting is 2-5.
I've made series of tests that showed descreased performance of nested sps in 1.5 times vs. sequental execution of statements.