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

Written By
October 06, 2015 08:45AM
October 06, 2015 02:38PM
Re: Slow Join Performance
October 06, 2015 03:42PM
November 14, 2015 10:24AM
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.