MB Custom Table
MB Custom Table is an extension of the Meta Box plugin that helps you save data in a custom table instead of the default post/user/term meta table. All meta values are saved in a single row and each column will be a meta key.
This reduces the number of rows in the database, which can cause a performance issue when the data grows. And it lets you have all your data in one place, so you can easily view, edit, import, and export it.
Why use MB Custom Table?
By default, WordPress uses meta tables to store metadata (custom fields). To meet a wide range of needs, WordPress uses a flexible database structure, where each custom field is stored as a row with 4 columns. While it seems fine at first, when your data grows, the number of rows in the database increases very quickly.
Let's take an example: If you are using WooCommerce, each order (a custom post type) requires more than 40 custom fields as follows.
What if we can store all custom fields in a single row?
Something like in the first screenshot, where each custom field occupies only 1 column in the database. So with the case of WooCommerce orders, you only have 600 rows in the database for 600 orders. Also, all information about a single post can be viewed at once.
Benefits of the method
- The size of your database will be reduced
- Since all the custom field data is in the same row, your query will be faster and easier
- You can view all data at once using any database management tool
- You can export all data more easily by exporting only one table
To achieve these goals, the MB Custom Table extension is all you need.
MB Custom Table provides a simple API for you to create custom tables and store custom fields in custom tables. Works with all Meta Box plugin field types as well as all meta types (post, user, term). The extension uses a simple syntax to define the table and you will not have to change the definition of your meta table.
Features of MB Custom Table
- It uses the WordPress recommended method of creating custom tables, allowing you to update the table structure at any time.
- Provides a simple API to define the structure of the table.
- It works with any type of meta: post meta, user meta, term meta, comment meta.
- Provides an easy way to integrate with your existing meta boxes.
- Supports creating custom models that combine the post and post meta table into one.
Get now MB Custom Table.
The products published on the site are distributed under license GPL / GNU. Always remember to check our Terms of use Y Privacy Policy.
EN 
ES