Also, a lot of busy boards like mine prune posts to save space especially when we were running 5.x
How about counting the post counts from each member in the member files instead. This gives a true count and since this page will not be called every time someone visits it won't be such a load on the server.
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.