SQL Server Performance Forum – Threads Archive
Best method for getting total record countI have a system that contains about 1.5 mil rows of data that can searched by one or more criteria. The portal will only return back 300 results at a time which meets the client expectation. Essentially using a TOP 300 gives the matching results and performance is good. New requirement would still show the total matching records despite only 300 being returned. Something like Results 21-30 of 300 Total Matching 748,120. I notice that doing a statement like the following is quick – but is there a better way: SELECT COUNT(*)
FROM tblBigTable WITH (NOLOCK)
WHERE condition 1…
AND condition 2…
You don’t have to return all the rows to the client. You canpage across the resultset in SQL Server if there is a unique number in the resultset. Look for paging records in this forum. Gaurav
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
I can see the method used is only the way to get out the result, follow as suggested. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.