Tip of having faster 'select count(*) from table' of sql server, probably can use this as reference to check similar feature on other DB, if that hurt something - http://beyondrelational.com/blogs/nakul/archive/2011/04/04/measuring-the-number-of-rows-in-a-table-are-there-any-alternatives-to-count.aspx