Taxonomy with huge data

Events happening in the community are now at Drupal community events on www.drupal.org.
snowmanmh's picture

Hello Community,

for a Web 2.0 Community Page i need some tables with Data. E.G. Zipcodes, Countrys or other Tables with Sportswear ...

The Question is, can Taxonomy handles Big Tables or is the Bestter Way to make custom Tables and Read with PHP Code?

Best Regards!

Comments

Sure :) No problems. Might

xano's picture

Sure :) No problems. Might want to write your own queries though instead of using taxonomy_get_term() and stuff if you want to load a lot of terms programmatically, but the database itself is not a problem and you probably won't run into any 'trouble' at all as long as you aren't coding anything.

Erm...

sdrycroft's picture

Not quite true, Drupal has a bad habit of falling over with as little as 10K terms. The main offenders being taxonomy_get_tree, and the amazingly dumb _taxonomy_term_children (christ, that last one is such an awful function).

leftandright module

bangpound@drupal.org's picture

I don't know why sdrycroft doesn't mention his module http://drupal.org/project/leftandright

Is it ready for general use?

Is it ready for use...

sdrycroft's picture

I'd like to think it's ready for use, although it has only been tested on a limited number of servers which I have full control over. I'm keen for other people to try to use it, and let me know where the problems lie.

I tried it out at Drupalcon,

bangpound@drupal.org's picture

I tried it out at Drupalcon, and I found that it works in a charmed and magical way. It didn't work, and then I poked at it a lot... created a new vocabulary, generated a bunch of terms, and it worked.

I could not get the "regenerate" feature to work.

nested sets ftw.

catch's picture

You both know about this patch, but for anyone else who comes across this - somewhat similar approach to left and right being worked on as a core patch - http://drupal.org/node/344019

Needs a lot of review/work before it's committable but last time I looked was getting closer.

Taxonomy

Group organizers

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds: