Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+2 votes
744 views
in Q2A Core by
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?
Q2A version: 1.7

1 Answer

+2 votes
by
selected by
 
Best answer
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.
by
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!
...