Best practices for handling large query results

I am building out a dashboard within retool and many of postgresql queries that are returned can have lots of data, 135k rows. Any tips/tricks for dealing with this large amount of data within retool?

Hey @Nick_Michniok!

The new table component is optimized to handle a much larger number of rows but there can definitely still be limitations! Using server-side pagination is often something that will help folks, and there's some documentation on how to set it up here. That being said, optimizing your app's flow might depend a lot on your use case so I'd be curious to hear more.

Would you mind describing what you'll be doing with the data?