Hello All,
we are using 4 record in 1site and for every record summary screen awe are having a common interface.
We are using function executestoredprocedure() to get the data for the summary screen and
the store procedure is giving the output from 11 tables for just one id.
and we are getting performance issues. My concern is that using of function executestoredprocedure() is affecting it.
and what is the other substitute we can use in place of executestoredprocedure().
Thanks In Advance
Discussion posts and replies are publicly visible
Hi sahilb346 is there any specific reason behind opting for stored procedure instead of views or materialized view?
I believe, in your case, materialized view could be the best option, this will give you better performance as well.
However as @Justin mentioned, what do you mean by slow performance?
Did you try executing this procedure directly In DB, how much time it's taking to return the response?
There might be chances where your interface might be causing the performance issues.