CodeIgniter Forum System / Discussion Area

[eluser]Xeoncross[/eluser]
[quote author="Crimp" date="1222136647"]
Not much help, I know. This may just be a matter of personal preference.[/quote]

Since every site should use some form of caching - I think that running an extra COUNT query will be fine. I have loaded my system with 13,000 posts, 3,000 Topics and 3,000 users and even with 30 queries for the most advanced page it only takes 0.2 seconds on my slow system.

Add to that to fact that I would then cache that page for 1-2 mins and I don't have to worry about the load anymore. Saved me from adding UPDATE `post_count` WHERE `id` = 3... queries throughout my code.

Curious, why don't you use Active Record?

Who said I didn't