Performance optimization in a module

[Kogkalidis]

I make a blog module and now comes the pagination issue where I need the rows count for the respective calculations.

I have an idea to make a table lets say category_total where I will have 2 columns (category_id, total) where I will update the total once I add or delete something. I will delete the row only if the respective category gets deleted from the system.

Is it a good approach or you have something better in your mind? Thanx for your valuable time

[PrestaHeroes USA]

these might offer some insights on how to optimize pagination.  here are more search results

https://www.myprogrammingtutorials.com/create-pagination-with-php-and-mysql.html

https://stackoverflow.com/questions/3799193/mysql-data-best-way-to-implement-paging

https://www.xarg.org/2011/10/optimized-pagination-using-mysql/

and this is very good article...

https://dzone.com/articles/why-most-programmers-get-pagination-wrong

hope this helps