When is it appropriate to create a new table in the WordPress database?

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):

http://wordpress.org/extend/plugins/taxonomy-metadata/

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.

Related Posts:

  1. MySQL Database User: Which Privileges are needed?
  2. Database synchronization between dev/staging and production
  3. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  4. Safest way to bulk delete post revisions
  5. How can I make a WordPress database portable and url independent?
  6. WordPress Unit Testing – Cannot Create Tables
  7. Insert data in database using form
  8. Why does $wpdb return strings for mysql integer values?
  9. Dealing with Many Meta Values, 30+
  10. Has parent field in the table wp_term_taxonomy has term_id or term_taxonomy_id
  11. Is it possible to switch the data layer within WordPress?
  12. store simple data in get_option()
  13. How to delete outdated, wrongly sized images in _wp_attachment_metadata?
  14. Have multiple local wordpress installs share a wp-content folder and database
  15. BuddyPress: What’s the use of wp_bp_xprofile_data table and how does it get updated? [closed]
  16. How to implement content from external database into WordPress text page? [closed]
  17. Cloning and syncing a WordPress website
  18. What actions affect files, DB, or both?
  19. Add search Value to wp_list_table pagination
  20. stdObject stored in database. How does one convert it to usable format?
  21. Database with mixed collation (utf8mb4 & utf8_general_ci)
  22. How to fix unchanged URLs in Database after running serialized search and replace script?
  23. Merging WordPress posts from different databases
  24. Should non-WordPress data get its own DB?
  25. Who is responsible for data sanitization in WordPress development?
  26. Search and replace special characters (å,ä,ö) for image attachments only in database
  27. Adding a Table to the wordpress database
  28. Moving to another host; which tables to move in a database
  29. WordPress mysql table double prefixes
  30. Change WordPress prefix for only one table?
  31. input data and output table [closed]
  32. Retrieve data from the database to table such as comments in the admin control panel
  33. Localhost to Staging to Development Dynamic WP-CONFIG
  34. Setup 3 Sites To Connect To 1 Database and Share Data
  35. Uknown meta entries in wp_postmeta
  36. Change options table prefix only
  37. Query multiple tables at once?
  38. creating new field on mysql
  39. Why user_pass column in wp_users table is varchar(64)
  40. Why does changing Database Table Prefixes result in loss of content?
  41. Can local WordPress installs share /wp-content/ folder and database?
  42. Can I customised default WP table
  43. Should I use an additional column in the DB?
  44. SymmetricDS in dev + prod workflow?
  45. Will adding & modifying default WordPress table index break future WordPress update
  46. What is wrong here? Issue with post_id and meta_value
  47. Custom Database Table and foreach
  48. What is my error trying to create a new table in the database?
  49. How to edit custom table data in frontend
  50. A WP dev site that displays content from a live site’s database but cannot write to wp_posts?
  51. How to map data on CSV to web pages?
  52. WPCLI search and replace in a particlar site dir effect another site-dir
  53. Merging development site with live site
  54. One WP Database outside localhost and two connections
  55. Get id from database
  56. Display single post inside accordion based on form submission results
  57. Database custom table issues – incorrect result displayed
  58. Share WordPress Database
  59. MySQL Database User: Which Privileges are needed?
  60. Create hundreds of users with just ID in phpMyAdmin
  61. Have WordPress Use a Different Database for users
  62. #1067 – Invalid default value for ‘post_date’ when trying to create a new column
  63. Database table prefix different between wp-config.php and in database
  64. Count views without get_post_meta
  65. What is an ORM, how does it work, and how should I use one? [closed]
  66. What is the difference between an ORM and an ODM?
  67. What is this JavaScript “require”?
  68. Rename a table in MySQL
  69. How should I tackle –secure-file-priv in MySQL?
  70. What is this JavaScript “require”?
  71. What is “Advanced” SQL?
  72. What’s the difference between identifying and non-identifying relationships?
  73. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  74. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  75. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  76. What are the differences between B trees and B+ trees?
  77. MySQL SELECT increment counter
  78. How to resolve ORA-011033: ORACLE initialization or shutdown in progress
  79. Example of a strong and weak entity types
  80. Oracle SQL query for Date format
  81. phpMyAdmin – Error > Incorrect format parameter?
  82. Strange Characters in database text: Ã, Ã, ¢, â‚ €,
  83. Difference between partition key, composite key and clustering key in Cassandra?
  84. How SID is different from Service name in Oracle tnsnames.ora
  85. What is a relation in database terminology?
  86. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  87. Database vs File system storage
  88. Can I have multiple primary keys in a single table?
  89. Exclude Statement in SQL
  90. How do you query for “is not null” in Mongo?
  91. What is a file based database?
  92. Is it fine to have foreign key as primary key?
  93. Storing Images in DB – Yea or Nay?
  94. Using wpdb to connect to a separate database
  95. how to Optimize WordPress database for 10 million post? [duplicate]
  96. Why is my database import losing text widget data?
  97. Keeping WP database synced across multiple developers using git
  98. WPDB Insert or if exists Update
  99. Multiple developers / editors working on a site in progress
  100. Where are wordpress custom types stored?

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)