I have a large data set that the query chokes on when I’m making changes… typically just adding/removing a LIMIT on the query to go from testing to production.
Is there a way to prevent the “preview” of the query? Appsmith kind of chokes and the page becomes unresponsive.
We are working on performance upgrade to be able to handle larger query datasets in a more performant manner.
In the meantime, I would highly suggest server-side pagination. This ensures that your page loads quickly & Appsmith doesn’t choke on large datasets because the amount of data being fetched is limited at all times.
Check out Display Data in Tables - Appsmith for instructions on how to enable pagination in your SQL queries within Appsmith.