Hi All,
Whats the difference between query entity and execute stored procedure function from the execution stand point. When we get the data from tables or views.
Will there be any heap issues when we use executestoredprocedure function? what are the pros and cons of using executestoredprocedure() functions.
Discussion posts and replies are publicly visible
Also, just to add an another point, if you are on Appian 18.4 or later version of Appian, then you do have the opportunity to reduce the number of calls (from 2 to 1) while using queryEntity, by the help of fetchTotalCount parameter of this function.
Means, if you set this as false then Appian will not perform an additional query to get the totalCount, (but you should do this when you are expecting this data to represent on a grid).
Also, if you are using a View which returns huge amount of data, then you should consider switching to a Table or Materialized View to improve the performance.
if the number of rows returned from the stored procedure is 20 rows.. will it cause the heap issue?