Meta Optimizer

This plugin optimizes WordPress meta data storage by saving all meta data for each post, comment, user, or term in a single row with separate columns for each meta key. This reduces the number of rows and improves the query performance and data export. The plugin works seamlessly with WordPress core functions and hooks, and supports any plugins that use them. Some of the features of this plugin are:

• Custom database tables for each type of meta data (post, comment, user, term)
• Compatibility with WordPress queries
• Faster queries and easy data export
• Data migration from default WordPress meta tables
• Option to exclude specific fields from core meta tables
• Support for popular plugins and themes such as Advanced Custom Fields, Meta Box, CMB2, and more.

1. 

   Tables tab, You can manage meta table columns.

2. 

   Reset section in tables tab, You can reset Meta Optimizer DB tables and import again meta data.

3. 

   Settings tab, Plugin options.

4. 

   Import tab, Import options.

5. 

   Tools tab, Optimize WordPress functionality

6. 

   Optimizer tab, Optimize WordPress Database

7. 

   Preview of table structures

1.4

• Add a Tools tab to enhance WordPress functionality
• Add an Optimizer tab to improve WordPress database performance
• Show the size of each plugin table in the tables tab

1.3

• Add a filter for changing import item numbers (Documentation)
• It is now possible to change the indexes of DB tables
• You will be able to reset the plugin’s database tables
• The import tab now includes an estimate of import time

1.2.2

• Fix save array when insert new meta row

1.2.1

• NumericVal meta value & change field type when create db table field

1.2

• Fix bugs effected on save meta array value
• Improve the import process

1.1

• Fix bugs effected on save meta array value

1.0

• Release first version of plugin
• Support get/add/update/delete meta functions and WordPress queries