Sql with a table with 100000 records slow query

💬 Queries and Resources
21

Yea i got that but i have then my select rowcount - what you said?

22

SELECT
COUNT(*) - {{table1.pagination.pageSize}} as count
FROM
tbl_clientes;

23

Hi @agaitan026,

Since we're trying to query for the total number of rows possible, you can remove any references to the table's page size.

If you run into questions after removing {{table1.pagination.pageSize}}, we'd love to take a look tomorrow in office hours :blush:

1 Like
24

Yes it works with and without