MySQL Forums
Forum List  »  Performance

Re: Slow on multiple joins
Posted by: Rick James
Date: November 20, 2012 09:16AM

The two EXPLAINs you presented are _not_ the explain for the SELECT with the JOINs.

Please use SHOW CREATE TABLE; it is more descriptive than DESCRIBE.

But, anyway, I recognize the horrible design pattern. Here's a discussion about why it is bad, and what to do instead:

http://mysql.rjweb.org/doc.php/eav

Options: ReplyQuote


Subject
Views
Written By
Posted
2519
November 19, 2012 05:10AM
1152
November 20, 2012 05:45AM
Re: Slow on multiple joins
1028
November 20, 2012 09:16AM


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.