ey @Kabirdas i got a issue i think its almost the same, i got a big table with 100k records, first in the table im using SELECT *, DATE_PART( 'YEAR', AGE (CURRENT_DATE, tbl_clientes.fechadenacimiento) ) as edad FROM tbl_clientes limit {{ table1.pagination.pageSize }} offset {{ table1.pag…

I think the setup you have right now is good @agaitan026 ! You could try: Original query with no filters Query JSON with SQL query with filters but no pagination Set Query JSON with SQL query to table Use client-side pagination on table But that might or might not be more performant depending on …

Filtering SQL query on paginated table

💬 App Building

agaitan026 October 23, 2023, 9:49pm 2

did you fixed the issue? having the same here

Topic		Replies	Views
Sql with a table with 100000 records slow query 💬 Queries and Resources	24	3122	December 4, 2023
Prev next rows in table to navigate between rows 💬 App Building	32	1090	May 22, 2025
Strange behavior using server side pagination 💬 App Building	7	409	December 11, 2023
Large database query pagination 💬 App Building sql , table	1	1172	February 13, 2024
Pagination issue (client side) table 💬 App Building	5	698	February 12, 2024

Filtering SQL query on paginated table

Related topics