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.