When integrating an Aggregate with a table, you can limit the number of records using maxRecords. However, does the SQL executed on the server retrieve all records from the database and then return only up to maxRecords? Or does it fetch only the specified number of records (maxRecords) directly from the database?SQL like:
Select Top(20) name, age from Employee Select Top(20) name, age from Employee Offset 40
Hi,
Please check this post for detailed explanation
https://www.outsystems.com/forums/discussion/90927/keep-max-records-consistent-with-your-needs/
Hi,Please refer this document,https://www.outsystems.com/forums/discussion/34305/significance-of-max-records-in-aggregate-or-advanced-sql/Thanks,sahana
Hi Fly,
No, when you set the MaxRecords property in an Aggregate, the platform optimizes the SQL query executed on the server and it fetch only the specified number of records (maxRecords) directly from the database . It does not retrieve all records from the database and then filter them afterward. Instead, it applies the limit directly at the database query level.
hope it helps.
Hi Jozy,
That is not true. Max. Records delimits the number of records that are transfered from the database to the server, but it does not limit the number of records fetched by the database.
Thanks, ありがとうございます。
Hi @fly away ,
Kindly refer this link,
https://www.outsystems.com/forums/discussion/100645/sql-advance-max-record/
Thanks,
Sudha Narayanan