Make WordPress Core

Changes between Initial Version and Version 1 of Ticket #14558, comment 44


Ignore:
Timestamp:
03/04/2024 09:51:27 AM (9 months ago)
Author:
samjco
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #14558, comment 44

    initial v1  
    11== **I wonder if mysql table partitioning may help.**
    22
    3 So partitioning allows for virtual tables to be made based on either a KEY, HASH, Column, list.
    4 This acts a view but without the drawback.
     3So, What is MySQL Partitioning? (Percona.com)
     4Partitioning is a way in which a database (MySQL in this case) splits its actual data down into separate tables but still gets treated as a single table by the SQL layer. [https://www.percona.com/blog/what-is-mysql-partitioning/]
    55
    66**If plugin territory**
    7 I think having a simple button that fires to ALTER TABLE (wp_posts) and add in partitions based on the existing custom post types. For instance (I haven't tested):
     7I think having a simple button that fires to ALTER TABLE (wp_posts) and add in partitions based on the existing custom post types. For instance (I haven't tested, test your own risk):
    88
    99{{{#!php