FireDAC Components for Azure Analysis Services

Build 22.0.8462

ResponseRowLimit

The number of response rows to allow before erroring. Set to 0 for now limit.

Syntax


property ResponseRowLimit: Integer;

Data Type

Integer

Default Value

100000

Remarks

Selecting a lot of columns results in a number of crossjoins occurring under the hood when translated to something that is acceptable for Azure Analysis Services. This is not intuitive if you are not familiar with MDX. It can easily result in very large responses that time out. The ResponseRowLimit is designed to try and alert the user to understand what can be very expensive requests.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462