Number of registers in DreamFactory reponse

REST API
1

Hello!

I’m having a problem with the numbers of registers that DreamFactory is responsing when I make a research.

I have 5000 registers in a table, and i need to research all of then. But when I make a research with a limit of 5000, for example, DreamFactory is only responding with 1000 registers.

Any idea of how to change this? It’s a config issue?

2

You can edit config/df.php to increase from 1000, but you should consider using the limit and offset params to paginate the results. If you had millions of records loading all of them in a single query is not going to work.

config/df.php: ‘max_records_returned’ => env(‘DF_DB_MAX_RECORDS_RETURNED’, 1000),