Changes between Initial Version and Version 1 of Ticket #14558, comment 44
- Timestamp:
- 03/04/2024 09:51:27 AM (9 months ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #14558, comment 44
initial v1 1 1 == **I wonder if mysql table partitioning may help.** 2 2 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. 3 So, What is MySQL Partitioning? (Percona.com) 4 Partitioning 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/] 5 5 6 6 **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 ):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, test your own risk): 8 8 9 9 {{{#!php