Table in Retool Only Shows 1,000 Users Out of 5,000+ in Database

Hi!

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?

Thanks for your help!

Contact Retool Support

1 Like

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

Hey @Ioana_Popa!

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!

Hi @Ioana_Popa, in addition to the suggestions shared above, are we using the Retool API?

Yes, I am using Retool API.

The response should include values for total_count and next_token that we can use to implement server side pagination on your queries:

Let us know if you have any questions on how to use these values. :slightly_smiling_face:

Thanks for providing solution. I face error in this code.

Welcome to the forum @daldabr and @jeesylorie. :wave:
Are we seeing any errors?