MySQL Forums
Forum List  »  Performance

Re: Slow COUNT + GROUP BY
Posted by: Refael Dakar
Date: March 20, 2015 08:00AM

We added the 'FORCE INDEX' and it improved he time which used to be around 40s.

As for that index.. we have it.

We can't remove the outer query. What you suggest doesn't provide the required response. It'll only count the number of occurrences of every user.

Options: ReplyQuote


Subject
Views
Written By
Posted
1724
March 20, 2015 07:00AM
776
March 20, 2015 07:55AM
Re: Slow COUNT + GROUP BY
750
March 20, 2015 08:00AM
732
March 22, 2015 04:11PM
712
March 23, 2015 12:46AM
1090
March 23, 2015 02:45AM
980
March 23, 2015 04:30AM
893
March 23, 2015 06:04AM
755
March 23, 2015 08:13AM
767
March 24, 2015 02:02AM
755
March 24, 2015 02:51AM
780
March 24, 2015 03:37AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.