MySQL Forums
Forum List  »  Performance

Re: Slow Join Performance
Posted by: Dereck E
Date: October 06, 2015 03:42PM

Thanks Rick. I just figured out my issue. In MSSQL my blank values were NULL however when I imported the data file into MySQL they came in as empty strings. After reviewing the data, the join was resulting in over 140 Billion entries! Once I NULL'ed the empty strings, the count executed in about 10 seconds (40K results). After doing some reading I bumped up some memory settings and now it is running closer to 2 seconds.

Thanks again.

Options: ReplyQuote


Subject
Views
Written By
Posted
1304
October 06, 2015 08:45AM
782
October 06, 2015 02:38PM
Re: Slow Join Performance
761
October 06, 2015 03:42PM
788
November 14, 2015 10:24AM
572
November 26, 2015 02:39PM


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.