How an object property get its values? Still from sub-queries right?
Not sure I understand what you mean.
For example WooCommerce stores a large amount of data per order, product etc as meta key & values which could be saved as a flat table.
WooCommerce actually uses own tables:
thepracticaldev.s3.amazonaws.com/i...
PrestaShop, Drupal and other CMS/CMF/Frameworks use different DB schema. You shouldn't compare them directly, it's pointless.
so I ended up creating a flat table to store records instead of custom post type and custom meta fields
And that is absolutely fine. You're free to create your own tables if that makes your life easier/better.
Though many improvements in the frontend, WordPress core architecture could be improved too
Oh sooooo true! I wholeheartedly agree on this. There's so much to improve in WP core... And DB schema is a minor issue, to be honest.
An interesting read related to this reddit.com/r/Wordpress/comments/ee...
Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment's permalink.
Hide child comments as well
Confirm
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Not sure I understand what you mean.
WooCommerce actually uses own tables:
thepracticaldev.s3.amazonaws.com/i...
PrestaShop, Drupal and other CMS/CMF/Frameworks use different DB schema. You shouldn't compare them directly, it's pointless.
And that is absolutely fine. You're free to create your own tables if that makes your life easier/better.
Oh sooooo true! I wholeheartedly agree on this. There's so much to improve in WP core... And DB schema is a minor issue, to be honest.
An interesting read related to this reddit.com/r/Wordpress/comments/ee...