Fetch more than 1000 records in one step

Connecting to SQL
11

Hi Ben,

I’m using DreamFactory Version: 2.1.1 and hit this issue while trying to fetch more than 1000 rows from an Oracle DB. I included the count parameter in the API call and it listed the total number of records (currently a little above 41,000 Records) as well as the actually number of fetched records 1000.

My question is two fold:

  1. Is the max_records_returned parameter the ONLY parameter to change this limit of 1000? I did this and still found that this was still fetched ONLY 1000 records? I restarted the instance and even cleared the cache but this has no impact on increasing the number to what was set (which in this case was 3000 rows)

  2. Assuming this default of 1000 - can i go around this by pagination or fetching subsequent records after the first 1000? If so how do i go about this?

Regards