MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Get statistics using self joins
Posted by: Harutyun Drnoyan
Date: May 18, 2009 03:24AM

Hello.

I've tried sub-query approach and it solved my issue. With data more than 45 000 000 rows it takes ~ 6 seconds to get statistics of 2 months per day basis. This is amazing result I think.

Thank you for your great help, Rick.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Get statistics using self joins
6035
Harutyun Drnoyan
May 16, 2009 10:40AM
Re: Get statistics using self joins
1976
Rick James
May 16, 2009 07:42PM
Re: Get statistics using self joins
2169
Harutyun Drnoyan
May 17, 2009 11:41AM
Re: Get statistics using self joins
1991
Rick James
May 17, 2009 12:32PM
Re: Get statistics using self joins
2072
Harutyun Drnoyan
May 17, 2009 12:48PM
Re: Get statistics using self joins
1961
Harutyun Drnoyan
May 18, 2009 03:24AM


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.