[drupal-devel] Folksonomy: No taxonomy.module Changes / URL Design

[Julian Bond]

Chris Johnson <chris at 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/