Environment: 7.9, No Hotfixes I'm running into some pretty strang

Environment: 7.9, No Hotfixes

I'm running into some pretty strange behavior that hopefully the community can help me with. A query entity is used to query a View, the entity selects only about half the columns in the view, filters on one column, sorts on another, and limits the batch size to 20. The rule errors out with: a!queryEntity: An error occurred while retrieving the data. (APNX-1-4198-000). And we believe this to be a timeout error.

However, simply changing the batch size from 20 to -1 allows the queryEntity to run without error.

Why would the query time out when attempting to limit results to 20, but successfully runs (returning approx 700 rows) when not limiting the results? Is this addressed in a Hotfix? Is there some other platform setting to suspect? Could I avoid this error by switching to a query rule and passing a paging info with 20 batch size?

OriginalPostID-173242

OriginalPostID-173242