MB Custom Table
MB Custom Table is an extension of the Meta Box plugin that helps you save data to 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 as the data grows. And it allows you to 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 metatables to store the 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’re using WooCommerce, each order (a custom post type) requires more than 40 custom fields as follows.
What if we can store all the custom fields in a single row?
Something like in the first screenshot, where each custom field takes up only 1 column in the database. So, with the case of WooCommerce orders, you only have 600 rows in the database for 600 orders. In addition, all the information about a single post can be viewed at once.
Benefits of the method
- Your database size will shrink
- Since all the data in the custom fields 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 the data more easily by exporting just one table
To achieve these goals, the MB Custom Table extension is all you need.
MB Custom Table provides a simple API so you can create custom tables and store custom fields in custom tables. It works with all field types in the Meta Box plugin, as well as all meta types (post, user, term). The extension uses simple syntax to define the table, and you won’t have to change the definition of your target box.
Features of MB Custom Table
- It uses the recommended WordPress method to create custom tables, allowing you to update the table structure at any time.
- It provides a simple API for defining the table structure.
- It works with any type of meta: post meta, user meta, term meta, comment meta.
- Provides an easy way to integrate with your existing target boxes.
- It supports the creation of custom models that combine the publication and the publication metatable into a single publication.
Get MB Custom Table now.
Reviews
There are no reviews yet.