Performance issues

luis1705

New Member
YetiShare User
Wurlie User
Aug 12, 2012
18
0
0
#1
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
1,610
15
38
mfscripts.com
WEBSITE
https://yetishare.com
LOCATION
UK
#2
Hi,

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

What version of the script are you using?

Thanks,
Adam.