Thanks Jaydub,<div> Thanks for letting me know about this module.</div><div><br clear="all">Thanks & Regards<br>Vasanth Govind<br><br>
<br><br><div class="gmail_quote">On Sun, Dec 14, 2008 at 5:11 PM, tbjkids Webmaster <span dir="ltr"><<a href="mailto:scripts@truerun.com">scripts@truerun.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Hi Vasanth,<br>
<br>
I've recently created this project which might be what you are looking<br>
for:<br>
<br>
<a href="http://drupal.org/project/node_extended_stats" target="_blank">http://drupal.org/project/node_extended_stats</a><br>
<br>
I've only got a d5 version right now but with some Views 2 wizardry it<br>
could be ported to d6.<br>
<br>
-jaydub<br>
<br>
<br>
<br>
> Hi all,<br>
> The requirement is to display the popular content of this week and popular<br>
> content of this month.<br>
> This is done by fetching the content which has more number of hits or<br>
> views.<br>
><br>
> We have Drupal's node_counter table in which we have the totalcount and<br>
> daycount fields which has views per day and total.<br>
><br>
><br>
> Any one help me optimized MySQL query which can fetch this details in a<br>
> quicker way.<br>
><br>
> Currently the data is fetched from accesslog table which is not much<br>
> optimized and very slow.<br>
> Thanks in advance.<br>
><br>
><br>
><br>
> Thanks & Regards<br>
> Vasanth Govind<br>
<font color="#888888"><br>
<br>
<br>
<br>
--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
</font></blockquote></div><br></div>