Working with large (Drupal) taxonomies

Drupal is great and the taxonomy system is great - but large taxonomies (over 1,000 terms are a headache for any system) and Drupal is no different. I have a new taxonomy for a project with > 5k terms in a three deep hierarchy and using it presents some usability, performance and other issues.
So I though I would take a break and write a bit about evaluating some Drupal contributed modules for working with large taxonomies:

  • Taxonomy Super select: Changes the multiselect box to check boxes - chokes on large lists
  • Taxonomy Tree Select: Promising and uses JQuery to create a tree view from a hierarchical taxonomy - but chokes on large taxonomies
  • Hierarchical Select: Promising and works well - but also fails with large taxonomies.
  • Big Taxonomy Autoselect: Perfect if you know the term you want to add as it autocompletes (showing the hierarchy path and the term id)
  • Left and right: Contibuted a patch and will report back on how this works out - looks like it will be the solution.

Generally any user of large taxonomies (1k+ terms) faces the same issues: database access and large returned result sets, client side processing and timeouts on requests and database connections - or simply horrible user experience of large large lists. We developed a solution for the NHM ten years ago which provided an efficient query path using warehoused relations allwoing the speedy navigation of taxonomic hierarchies - I think we need to port this to a Drupal module - see it in action here.

I'll update this post with more 'large taxonomy' conclusions and issues once I have completed this phase...

TaxiSelect - Great Drupal Module for large taxonomies

Check out TaxiSelect its a great Drupal taxonomy selection module that dose not use CCK but the core taxonomy system.
Looks like it works well with large taxonomies ( my one isent that big so cant vouch for it).
No Drupal 7 yet but a plane is on the table (looking for contributes to help out)

TaxiSelect - great module

Its a great simple module the only small issue i have with it is that the Remove checkbox is available when the vocabulary is set to Required.
Its not a major issue as Druapl want let you save if no term exists for the required vocabulary.

Comparison of CCK/Taxonomy Modules

A discussion about CCK/Taxonomy Modules on drupal.org
Comparison of CCK/Taxonomy Modules however it does not deal with the performance and usability of large taxonomies

Taxonomy solutions

I was looking for a way to add checkboxes to taxonomies. Your post gave me a lot of solutions. Fortunately for me I won't need more than 100 taxonomies so existing solutions should work.

BTW, the link you posted is not working. I was curios to how it works on a large taxonomy.