Performance issues

[luis1705]

My logs report this query to be slow (+60 seconds).

SELECT COUNT(id) AS total, shortUrl FROM shorturl WHERE status='active' GROUP BY shortUrl ORDER BY visits DESC LIMIT 10

on my setup when accessing the admin panel of short url. I believe that query is being called for the top 10 table. My setup has 2.3 million short urls.

 

[adam]

Hi,

I assume this is for Wurlie? I'll move the post.

What version of the script are you using?

Thanks,
Adam.