Hub Server Simple Query Optimization

Hub Server Simple Query Optimization

Hello Everyone,

I know that simples queries in preparation screens have an excellent optimization mechanism, that is the fact that only the used ENTITY parameters are actually retrieved from the database by the Hub Server.

What I would like to know is: if I have a query from which I use only the Query.ReturnedRowCount property, does this mean that no records are retrieved from the Database? (making it possible to be a good alternative to a count in advanced queries).

My question is motivated by the fact that the Style Guide listing patterns use advanced queries to perform counts, what might become harder to maintain in case the advanced query gets complex.

Best Regards,

Daniel Lourenço