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

3038

Anderson Scouto da Silva Dan

February 28, 2015 03:15AM

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

2687

Øystein Grøvlen

March 02, 2015 02:05AM

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

1124

Øystein Grøvlen

March 02, 2015 02:13AM

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

1687

Anderson Scouto da Silva Dan

March 02, 2015 02:28PM

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

1145

Øystein Grøvlen

March 03, 2015 01:27AM

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

1345

Rick James

March 02, 2015 06:13PM

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

1017

Anderson Scouto da Silva Dan

March 02, 2015 07:14PM

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

1060

Anderson Scouto da Silva Dan

March 02, 2015 07:20PM

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

This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.