I have a table that has a very high usage (insert/update/select) - one of the operations is
to obtain a count of the number of rows.
So far I've been using the classic select count(pk) from table
but I'm thinking to read it from information_schema instead of doing the count.
select table_rows from tables where table_name = 'my_table'
Is this reliable enough ?
If there is a different method please let me know.
thanks!