Setting default LIMIT on Remote SQL DB Services?

Hi -

It appears with my PostgreSQL connection, if the LIMIT isn’t provided in the GET query, by default, it’ll return 1,000 rows.

Is there a way to change this default, say down to 250 rows?



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


That did the trick - thanks Ben!