[support] week's and month's popular content

[Vasanth Govind]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20081213/abd6f602/attachment.htm