MaxRecords

Data Abstract
1

hi, if i run sql server profiler i don’t see that when I set MaxRecords clientside, that the query itself runs with TOP(maxrecords)…
so is it correct that MaxRecords will restricts the records in code after being fetched from sql server?

2

Hi,

it depends on SQL you are using:

  • for AutoSQL mode - we generate TOP/FIRST
  • for manual SQL mode - we restrict records after fetching because you can don’t modify original sql.