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.
Best answer by Dinushi Liyanage
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!
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.
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!
