- any alternate way of achieving my goal of a fast row count
How accurate does your count need to be? One idea would be to set up some sort of periodic background task which computes the current sizes of your tables and stores that information in another table in your database.
Then, when you needed the count, you could simply read it from your stored-counts table. You could adjust the frequency of the background task to improve the accuracy of the count. thanks, bryan
