Why are post tags stored in the qa_posts table as a comma separated list?

Question 1

Why are post tags stored in the qa_posts table as a comma separated list in a field as opposed to being normalised in their own table?

Question 2

I'm not sure why you say they don't have their own table, because they do. Take a look again at the schema.

Anyway, apart from being normalized, it is also denormalized to speed up some queries, saving a couple of joins.

Question 3

Oh my God! You're right! I just overlooked it!

I've spent 2 days trying to figure out a way around this and have finally started developing a plugin to create a post_tags table!

Thank you for the update - appreciated!

pupi1985 · Answer 1 · 2015-02-09T19:03:49+0000

I'm not sure why you say they don't have their own table, because they do. Take a look again at the schema.

Anyway, apart from being normalized, it is also denormalized to speed up some queries, saving a couple of joins.

Oh my God! You're right! I just overlooked it!

I've spent 2 days trying to figure out a way around this and have finally started developing a plugin to create a post_tags table!

Thank you for the update - appreciated! — delstone, Feb 9, 2015

Why are post tags stored in the qa_posts table as a comma separated list?

Please log in or register to add a comment.

Please log in or register to answer this question.

1 Answer

Please log in or register to add a comment.

Categories

Why are post tags stored in the qa_posts table as a comma separated list?

Please log in or register to add a comment.

Please log in or register to answer this question.

1 Answer

Please log in or register to add a comment.

Related questions

Categories