I have made a custom dreamfactory docker setup to work with postgresql . here are details.
DreamFactory Version: 2.14.0
System Database: pgsql
Install Path: /opt/dreamfactory/
I am trying to set the max records returned to 99999 in .env file
DB_MAX_RECORDS_RETURNED=500
DF_DB_MAX_RECORDS_RETURNED=500
but it does not work any suggestions . please help stuck on it for a while .
1 Like
Hi @regalartech,
After you changed the DB_MAX_RECORDS_RETURNED to 99999, is it uncommented in the .env file ( I am assuming so based on the code snippet you posted, but wanted to make sure). Also, did you clear the cache and config via these commands:
php artisan cache:clear
php artisan config:clear
One last thing to try, try raising the limit on the DB service page to 99999 and saving the service, then refreshing the system cache on the Config
tab.