Chris Johnson <chris@tinpixel.com> Thu, 10 Mar 2005 18:56:49
I see a lot of advantages to staying tightly bound with taxonomy. The only disadvantage I worry about is ultimate taxo/folkso performance when both are in heavy use on a site. And that's just a knee-jerk reaction; have not looked at the code and SQL.
The nasty SQL is - Get all terms ordered by usage count desc for this vocabulary. This is "Popular" terms and might be further limited by user. - Get all terms ordered by usage count desc for this vocabulary that appear along side this term on nodes. This is related terms for this term. I think the rest of it is not too bad. Even with a few thousand terms on a few tens of thousands nodes. I suspect that some work ought to be done on term_data and term_node indexes. -- Julian Bond Email&MSM: julian.bond at voidstar.com Webmaster: http://www.ecademy.com/ Personal WebLog: http://www.voidstar.com/ M: +44 (0)77 5907 2173 T: +44 (0)192 0412 433 S: callto://julian.bond/