MySQL :: Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow

Contact MySQL |
Login | Register

The world's most popular open source database

Documentation Downloads MySQL.com

Developer Zone

Section Menu:

New Topic

Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow

Posted by: Øystein Grøvlen
Date: March 02, 2015 02:13AM

Hi again,

Rereading your post, I think that I have probably misunderstood something. You say:

"I can not remove the joins as they are used where, removed to get better
understanding."

I am not able to understand what you are trying to say here, but it seems to be relevant. Please, explain.

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Views

Written By

Posted

COUNT with GROUP BY, JOIN and SUBQUERY very slow

2944

Anderson Scouto da Silva Dan

February 28, 2015 03:15AM

Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow

2577

Øystein Grøvlen

March 02, 2015 02:05AM

Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow

1083

Øystein Grøvlen

March 02, 2015 02:13AM

Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow

1646

Anderson Scouto da Silva Dan

March 02, 2015 02:28PM

Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow

1098

Øystein Grøvlen

March 03, 2015 01:27AM

Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow

1282

Rick James

March 02, 2015 06:13PM

Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow

972

Anderson Scouto da Silva Dan

March 02, 2015 07:14PM

Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow

1015

Anderson Scouto da Silva Dan

March 02, 2015 07:20PM

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.