How an object property get its values? Still from sub-queries right? 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.
PrestaShop saves order data much effectively and its easy to access through object properties and performance is much better.
Drupal creates tables for every field and their revisions, a better approach.
I had to store records with post_ID and associated values as meta_data. They are not hierarchical or can be grouped as taxonomy, so I ended up creating a flat table to store records instead of custom post type and custom meta fields.
Though many improvements in the frontend, WordPress core architecture could be improved too my two cents.
How an object property get its values? Still from sub-queries right? 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.
PrestaShop saves order data much effectively and its easy to access through object properties and performance is much better.
Drupal creates tables for every field and their revisions, a better approach.
I had to store records with post_ID and associated values as meta_data. They are not hierarchical or can be grouped as taxonomy, so I ended up creating a flat table to store records instead of custom post type and custom meta fields.
Though many improvements in the frontend, WordPress core architecture could be improved too my two cents.
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...