I am developing a forum like app using a MySQL database. I have posts, comments and replies just any other forum.
At the moment I have a table for posts, a table for comments/replies and a table for user/object relationships.
Lately, I have been studying WordPress CMS database structure and I've noticed that all the above are under a single table and there is a field 'post_type' that determines the object's type (eg post, comment or reply).
I have come to discover that this is very flexible for this site's purposes but is it wise in terms of speed?
Additionally, I was thinking of using an additional database such as ElasticSearch just for quering and MySQL only for storing.
What are your thoughts on this approach? Advantages/Disadvantages?
Thank you in advance :)