Solved

Limitation in Aurena when retrieving large data sets using Business Reports

  • 6 February 2022
  • 2 replies
  • 89 views
B
Rank
Badge +3

In Aurena, It is noticed that when we change the maximum number of rows for business reports there is a note stating “Max number of rows that by default will be retrieved in a data set during report execution. Should only be modified of there is a need to retrieve large data sets, which might affect performance and lead to memory issues”

 <see the attachment>

Could you please let me know whether there is any limitation in Aurena when retrieving large data sets using Business Reports ?

Your feedback and recommendations on this is highly appreciated.

icon

Best answer by Dinushi Liyanage 17 March 2022, 18:36

View original
1 Attachment
This topic has been closed for comments

2 replies

Dinushi Liyanage
Rank
Userlevel 5
Badge +11

Hi @bhhelk ,

The parameter you have mentioned specifies the maximum number of records to retrieve for one data set (one SELECT statement) from the database. The purpose of the parameter is to avoid deadlocks if a query retrieves huge number of rows. Default value is 65000 records per one SELECT statement.
Note that this parameter is optional to configure. The default settings should be enough for most cases.

Kind regards,
Dinushi

Dinushi Liyanage
Rank
Userlevel 5
Badge +11

Hi @bhhelk ,

The parameter you have mentioned specifies the maximum number of records to retrieve for one data set (one SELECT statement) from the database. The purpose of the parameter is to avoid deadlocks if a query retrieves huge number of rows. Default value is 65000 records per one SELECT statement.
Note that this parameter is optional to configure. The default settings should be enough for most cases.

Kind regards,
Dinushi

Hello,

Glad if you could mark this as the best answer if it answered your question.
Thanks!

Kind regards,
Dinushi

Terms & ConditionsCookie settings