# Setting default LIMIT on Remote SQL DB Services?

**URL:** <https://community.dreamfactory.com/t/setting-default-limit-on-remote-sql-db-services/123>\
**Category:** Connecting to SQL\
**Created:** [June 28, 2014, 7:04pm UTC](https://community.dreamfactory.com/t/setting-default-limit-on-remote-sql-db-services/123 "2014-06-28T19:04:16Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![benbusse](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/benbusse/32/4_2.png) [@benbusse](https://community.dreamfactory.com/u/benbusse)\
**Post date:** [June 28, 2014, 7:10pm UTC](https://community.dreamfactory.com/t/setting-default-limit-on-remote-sql-db-services/123/2 "2014-06-28T19:10:27Z")

</div>

Hi Jason,

Yes, there’s a constant called dsp.db\_max\_records\_returned in config/common.config.php.

See this post [Fetch more than 1000 records in one step](https://community.dreamfactory.com/t/fetch-more-than-1000-records-in-one-step/97)

-Ben

---

_[View the full topic](https://community.dreamfactory.com/t/setting-default-limit-on-remote-sql-db-services/123)._