What's the correct way to implement server side pagination?

I have implemented server side pagination with OFFSET in a SQL data query. I also have another SQL query returning a count for my data query and set this values as the “Total Record Count” field in my table settings.

It seems that the table settings totally ignore my “Total Record Count” value and allow the pagination to continue forever. Even if I put a fixed value as “Total Record Count” the pagination still continues without end.

I am using v1.6.10 of appsmith running in a docker container.

Any suggestions?


@rymarczy you need to set a limit for the SQL. This is a document explaining the pagination