Why don't you get count at the beginning, store it in a variable and then simple refer to it instead of running query every time you refresh view.
peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster
SagarSe7en 0 Junior Poster in Training
SagarSe7en 0 Junior Poster in Training
SagarSe7en 0 Junior Poster in Training
SagarSe7en 0 Junior Poster in Training
SagarSe7en 0 Junior Poster in Training
javaAddict 900 Nearly a Senior Poster Team Colleague Featured Poster
peter_budo commented: One for sticking with this guy, and hard time spoon-feeding :) +16
SagarSe7en 0 Junior Poster in Training
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.