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