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? Link to comment https://forums.phpfreaks.com/topic/30531-searching-ads-under-arbitrary-number-of-categories/ 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? Link to comment https://forums.phpfreaks.com/topic/30531-searching-ads-under-arbitrary-number-of-categories/#findComment-142110 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.