phpPunk Posted December 13, 2006 Share Posted December 13, 2006 Each item is associated with a single categorey, but if an item is placed under say "Child" which is a child of category "Parent" then when someone is viewing "Parent" they would also see all of it's child items as well...Currently I have a function pull all of a "Parent" child ID's and pass that to a IN(1,2,4,5,6) clause...Obviously not overly efficient, but I can't think of anything else, outside of associating each ad with multiple categories instead of just using a single category ID...Assuming I like the IN(x,x,x,x) approach what are some MySQL specific (or SQL ingeneral) optmizations I can apply to speed things up???Make sure each catid (ie: catid IN(x,x,x,x)) is an index? Anything else? Quote Link to comment Share on other sites More sharing options...
fenway Posted December 16, 2006 Share Posted December 16, 2006 I'm not sure I understand... obviously, IN() clauses are basically ORs, so they're not that efficient... can you just JOIN these tables? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.