I'm encountering an issue when trying to display a full list of users from our database in Retool. In our database, we have over 5,000 users, but when I create a table component in Retool, it only shows 1,000 records. I’m not able to view or access the remaining users in the table, and I haven't been able to find a setting or option to display all records.
Is there a limit in Retool on the number of rows that can be displayed in a table component? If so, is there a way to increase this limit or implement server-side pagination to access all records?
Hi, not sure how you're connecting to your DB but there might be a limit on how many records can be fetched through your connection at one time. Ex. Using pagination in the REST API - GitHub Docs
Like @Mariusz_Kolaszewski said, how you're accessing the database plays a big role, but —5000 records is a lot to handle at once. I wouldn’t be surprised if Retool had some limitations to avoid performance or memory issues.
I’d definitely recommend using pagination to make things run smoother and load faster. It might complicate filtering a bit, but sending 5000 rows to the frontend all at once is quite a lot to manage!