Posts: 18
Forum Level: YetiShare, Wurlie, Premium Member
Joined: Sun Aug 12, 2012 3:05 am

Performance issues

Wed May 10, 2017 2:05 am

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

Code: Select all

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.

This thread has 1 reply

You must be a registered paid member and logged in to view this response.


Return to “Technical Support”

Who is online

Users browsing this forum: No registered users and 1 guest