MySQL Forums
Forum List  »  Newbie

Re: Opinions on this schema please =)
Posted by: Rick James
Date: February 22, 2009 02:13PM

(select ... from ... where general_category = xx) --
Add that column to your main table; index it; and do a JOIN instead of a subselect.

"selects can be tampered with later on anyways" -- I'm trying to warn you that tampering with the selects (and indexes) probably won't suffice; the problems are rooted in the underlying schema design.

According to the textbooks, your schema is nicely designed. But the textbooks don't worry about performance and scaling.

Options: ReplyQuote

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.