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

[Vasanth Govind]

Thanks Jaydub,  Thanks for letting me know about this module.

Thanks & Regards
Vasanth Govind



On Sun, Dec 14, 2008 at 5:11 PM, tbjkids Webmaster <scripts at truerun.com>wrote:

> Hi Vasanth,
>
> I've recently created this project which might be what you are looking
> for:
>
> http://drupal.org/project/node_extended_stats
>
> I've only got a d5 version right now but with some Views 2 wizardry it
> could be ported to d6.
>
> -jaydub
>
>
>
> > 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
>
>
>
>
> --
> [ Drupal support list | http://lists.drupal.org/ ]
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20081216/4b588cb5/attachment-0001.htm