# Number of registers in DreamFactory reponse

**URL:** <https://community.dreamfactory.com/t/number-of-registers-in-dreamfactory-reponse/2029>\
**Category:** REST API\
**Created:** [January 13, 2016, 1:01pm UTC](https://community.dreamfactory.com/t/number-of-registers-in-dreamfactory-reponse/2029 "2016-01-13T13:01:06Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![nankran](https://avatars.discourse-cdn.com/v4/letter/n/90db22/32.png) [@nankran](https://community.dreamfactory.com/u/nankran)\
**Post date:** [January 13, 2016, 1:01pm UTC](https://community.dreamfactory.com/t/number-of-registers-in-dreamfactory-reponse/2029/1 "2016-01-13T13:01:07Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![toddappleton](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/toddappleton/32/159_2.png) [@toddappleton](https://community.dreamfactory.com/u/toddappleton)\
**Post date:** [January 13, 2016, 2:49pm UTC](https://community.dreamfactory.com/t/number-of-registers-in-dreamfactory-reponse/2029/2 "2016-01-13T14:49:32Z")

</div>

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),