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:
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...
info [at] blue-bag.com
Telephone: 0843 2894522
Blue-Bag HQ: The Garage, Manor Farm Chilcompton, Radstock Somerset, BA3 4HP, United Kingdom
Telephone: (+44) 01761 411542
Blue-Bag Brighton: Unit 35 Level 6 North, New England House New England Street, Brighton BN1 4GH United Kingdom