Hi All,
Is there any most efficient way to get a total count of a large data set of an Entity without pulling all the data itself from the data set . Use case is to retrieve only total no records in an enitity.Thanks in advance.
Discussion posts and replies are publicly visible
Another thing you might consider this app https://community.appian.com/b/appmarket/posts/execute-stored-procedure from the app market. You can use that to execute a SQL stored procedure, or more precisely a FUNCTION that returns the count of that table.
In essence taking advantage of the fact that SQL can count SQL faster than Appian can, which is what the custom View would also do.
Yup, I'd opt for a Stored Proc that effectively performs a SELECT COUNT(*) FROM <yourTable>