WordPress.org

Make WordPress Core

Changes between Initial Version and Version 1 of Ticket #12668, comment 37


Ignore:
Timestamp:
10/11/2014 06:27:59 PM (5 years ago)
Author:
judgej
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #12668, comment 37

    initial v1  
    55And yes, creating tables is a slippery slope.
    66
    7 However, custom tables can often be a much better fit for some purposes. Back to WooCommerce again, each order has a dozens of custom fields - order options, each part of each postal address etc. The rate at which the wp_postmeta grows as a result is frightening. I don't think WP was ever designed to be scaled in the direction that some of these plugins are taking it, and I hate to say it, but they really should be putting their data into more optimised tables of their own.
     7However, custom tables can often be a much better fit for some purposes. Back to WooCommerce again, each order has a dozens of custom fields - order options, each part of each postal address etc. The rate at which the wp_postmeta grows as a result is frightening. I don't think WP was ever designed to be scaled in the direction that some of these plugins are taking it, and I hate to say it, but they really should be putting their data into more optimised (i.e. flatter and wider) tables of their own.
    88
    99I think this is always going to be a problem as WP is pushed more away from its simple blogging roots; the people pushing it to its limits are moving faster than WP ever will, and the limits causing immense performance issues on some sites are being exposed.