Setting default LIMIT on Remote SQL DB Services?


#1

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?

Thanks,

Jason


#2

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

-Ben


#3

That did the trick - thanks Ben!