Fetch more than 1000 records in one step

Connecting to SQL
15

Hi guys,
I’m using DF Version 2.2.1, and I was stuck with this issue for two days, and the solution which worked out for me was:

  1. Change DF_DB_MAX_RECORDS_RETURNED in /dreamfactory-2.2.1-2/apps/dreamfactory/htdocs/.env to a higher value.
  2. Also change to
    ’db’ => [
    // The default number of records to return at once for database queries
    ’max_records_returned’ => env(‘DF_DB_MAX_RECORDS_RETURNED’, 100000),
    …
    ]
    in /dreamfactory-2.2.1-2/apps/dreamfactory/htdocs/config/df.php file.
    Hope this helps…
    Regards
1 Like