WordPress.org

Make WordPress Core

Opened 3 years ago

Closed 3 years ago

Last modified 10 months ago

#17477 closed enhancement (maybelater)

Simplify Taxonomy System

Reported by: mikeschinkel Owned by:
Milestone: Priority: normal
Severity: normal Version:
Component: Taxonomy Keywords: needs-patch 2nd-opinion dev-feedback
Focuses: Cc:

Description

Mark Jaquith has said he would like to see WordPress Simplify taxonomy table structure by merging term and term taxonomy tables.

Basically the idea (I think) is to merge the wp_terms table into the wp_term_taxonomy table. Will we keep the name wp_term_taxonomy or will it get changed to another table name, with a different schema, of course? And what should the updated schema be? Further, would doing this drive addition of taxonomy meta?

If this is going to be something addressed in WordPress it would be nice to kickstart the process sooner than later. This is coming up because it's a concern mentioned during our object relationships plugin discussion.

Change History (5)

comment:1 follow-up: nacin3 years ago

The general thought has been to denormalize wp_terms and wp_term_taxonomy by adding the name and slug fields to wp_term_taxonomy. This will allow us to avoid a join and ultimately phase out the table. Unfortunately, most of our API passes around term ID, rather than TT ID, so this will end up being nearly impossible. Rather, we'd likely need a new term/taxonomy API - probably object-oriented, if only because we've used up the function namespace for the existing API - that can be built with a future schema in mind.

Any desire to overhaul taxonomy from the ground up will need to come from a series of major discussions on the project's direction, not to mention a scope session, and won't happen in the near future. Sounds to me like that makes this ticket maybelater.

comment:2 scribu3 years ago

Subscribing, just in case.

comment:3 in reply to: ↑ 1 mikeschinkel3 years ago

  • Resolution set to maybelater
  • Status changed from new to closed

Replying to nacin:

Cool! Thanks for the details. I'll set to "maybelater."

Last edited 3 years ago by mikeschinkel (previous) (diff)

comment:4 ocean903 years ago

  • Milestone Awaiting Review deleted

comment:5 mboynes10 months ago

  • Cc mboynes@… added
Note: See TracTickets for help on using tickets.