use of function executestoredprocedure()

Question

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

aloks0189 · Answer

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.

Ranveer · Answer

I would suggest few options to optimize the code: 
 
 Create a view and do type cast in Appian to map into CDT. 
 Break the stored procedure into small part and execute on different section on user interaction. 
 If you Appian is upgraded to 17.4 you can use multiple query to get data because it will work in parallel processing which is efficient.