12 Dec
2008
12 Dec
'08
7:07 p.m.
Hi all, The requirement is to display the popular content of this week and popular content of this month. This is done by fetching the content which has more number of hits or views.
We have Drupal's node_counter table in which we have the totalcount and daycount fields which has views per day and total.
Any one help me optimized MySQL query which can fetch this details in a quicker way.
Currently the data is fetched from accesslog table which is not much optimized and very slow. Thanks in advance.
Thanks & Regards Vasanth Govind