Pagination help

[nomanmurtaza786]

Hello Guy, how I can show no more data thing with rang function?

[silentworks]

Take a look at my answer on this topic in this other discussion.

#1223 (comment)

[nomanmurtaza786]

Thanks mate, i have seen your answer, same things are available in flutter/ dart?

I have suggested can do make a trigger update total count on insert and delete. We can refer to that value instead of count. Can you help to write that trigger.
I think Count function is heavy for performance.

[silentworks]

That feels like premature optimisation, I don't think that is something you need to worry about at this stage. Also making two restful calls might be a longer roundtrip than a count function taking long due to the number of records.

[steve-chavez]

I think Count function is heavy for performance.

@nomanmurtaza786 @silentworks There's also the count: "planned" option, which uses the PostgreSQL planner statistics for the count - this one will be fast even with a big amount of rows.