I have to create a browse page like monter.com or dmoz directory. My problem is the counts for each category. What's the best practive to do a similar thing? I am using PHP/MySQL Thx!
views:
36answers:
2
A:
Did you try to implement it the way that you calculate these numbers dynamically when the page loads? How do you know that it is indeed a performance issue? Calculations are pretty fast these days.
Otherwise put a counter field next to each (sub-)category. When inserting(/deleting) a new post, then you update the counter of all categories it belongs to.
As a result, when you query any category, or set of categories, you will have a counter field for each giving the exact numbers of posts the category holds.
sibidiba
2010-06-23 12:10:03
I tryed to calculate these numbers dynamically when the page loads but it takes to much time, because for each geographique level I have to count the number of all sub level AND the count for each activity field. it's about 150 count a click.Denormalizing the table with adding a counting field in each category / sub category is not relevante because for each geo lvl I have fields of activity to denormalize I have to create count field for each geolocation and vice versa.There is no other issues to do like dmoz.org/Business or jobsearch.monster.com/Browse.aspx pages?
chahedous
2010-06-23 14:06:39
A:
Solr can do that with Faceted Search http://lucene.apache.org/solr/tutorial.html#Faceted+Search I'll test it now.
chahedous
2010-06-23 15:15:41