Performance issues

luis1705

New Member
YetiShare User
Wurlie User
Aug 12, 2012
18
0
0
My logs report this query to be slow (+60 seconds).

Code:
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

Administrator
Staff member
Dec 5, 2009
2,043
108
63
Hi,

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

What version of the script are you using?

Thanks,
Adam.