Hi!
I have an application with a lot of categories, and I want to list the
number of entries for each category. The object oriented way to do this
would be something like:
foreach ($categories as $category) {
echo $category->getName() . ' (' . $category->countArticles(). ')';
}
However, this means that I get one extra database-query per category (and
there can be quite a lot of them).
What's the best practice for solving this? I have considered writing custom
SQL, which would surely work, but at the same time break to OO-paradigm of
symfony, and also considered caching the action (but since the categories
are updated at least every few minutes, this would demand a lot of clearing
of the cache).
Any suggestions?
Thanks,
Gunnar Lium
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
