For a client we'll need 29,000 terms (all the highschool's in the US) and each term needs 6 meta items (address, phone...). My initial thought was to store the term meta information as suggested in this post but after looking through it again I will be using lots of terms and I wonder if it will overload the options table.

Is there a good time to create a new table? Would this qualify? Other thoughts on how to relate the HS that a person attends to the 'post' that will be their academic profile?

It was suggested that I make the 'terms' a Custom Post Type. I'm not opposed to that either but I fail to see how I'll relate the CPT to multiple 'authors' since a school will have more than one student that attends it. Because of the multiple ownership of the content terms just seemed to fit better.

  • 1
    I don't have an answer for you about when it's appropriate, but you might want to have a look at this plugin: wordpress.org/extend/plugins/simple-term-meta I use the method outlined in the article you linked, but not at such a huge scale. Commented Jul 29, 2011 at 16:41
  • Hrm that's interesting. I'll have to give it a go, wonder if it would be lighter on the DB? Commented Jul 29, 2011 at 16:49

1 Answer 1


As the article mentions, using wp_options is not a good idea when you have thousands of terms, mainly because there's:

  • a lot of serialization involved OR
  • long option names (the limit is 64 characters)

In this particular case, yes, it's appropriate to create some custom tables.

To save time, you can use this plugin (update more recently than Simple Term Meta):


Having said that, it looks to me like a custom post type would be better suited for this.

Take a look at my Posts 2 Posts plugin for relating highschools to whatever you were planning on relating them to.

  • That is the consensus. I should be using CPT's with Post 2 Posts or Relations. Commented Aug 1, 2011 at 21:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.