Pro item
Developer: Meta Box
Version: 2.1.10 report oudated
Updated: 26 March 2024
File status: Original
File name: mb-custom-table-2.1.10.zip

meta box custom table addon 2.1.10

Save custom fields data to custom table instead of the default meta tables. Reduce database size and increase performance. read more
1 users like this.
You don't have a valid membership to download this item. Purchase one here.

Other items in collection

meta-box-aio

At the moment, each extension of the plugin Meta Box is provided separately. They acts

Build front-end templates for WordPress without touching theme files. Support Twig and all field types.
The endless possibilities of Meta Box without the need to touch any code.
Show or hide meta boxes whenever and for whomever you choose.
Display custom fields in table columns in admin screens for All Posts (types).
Hang on. We're loading...

More items you'd like to see

Generates useful system information

Josh Admin template is a bootstrap based admin template which comes in following versions Laravel

For cleaner & SEO friendly filenames. The Pro users are given a few more features

Media Cleaner Pro is a tool that detect unused and useless files from your WordPress.

There are many great tools to get accurate statistics of your visits. But have you

Hang on. We're loading...
MB Custom Table is an extension of Meta Box plugin that helps you to save data to 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 let you have all of your data in one place, so you can easily view, edit, import, export it.
Save custom fields in custom table
Save custom fields in custom table

Why custom table for custom fields?

By default, WordPress uses meta tables for storing the meta data (custom fields). In order to satisfy a wide range of needs, WordPress use a flexible database structure, where each custom field is stored as a row with 4 columns: meta_idpost_idmeta_key and meta_value. While it seems to be fine at first, when your data grows, the number of database rows increase very fast. Let’s take an example: If you’re using WooCommerce, each order (a custom post type) requires more than 40 custom fields as follows:
Custom fields for WooCommerce orders
Custom fields for WooCommerce orders
Imagine if you run a flower shop, and have 20 orders per day, then WordPress will store 20 * 40 = 800 rows in your database. After 1 month, it will be 30 * 800 = 24.000 rows, for just 30 * 20 = 600 orders. What if we can store all the custom fields in a single row? Something like in the first screenshot, where each custom field takes only 1 column in the database. Therefore, with the case of WooCommerce orders, you only have 600 rows in the database for 600 orders. Besides, all the information about a single post can be viewed at once.

WHAT ARE THE BENEFITS OF THIS METHOD?

  • Your database size will reduce
  • As all the custom field data is on a same row, your query will be faster and simpler
  • You can view all the data at once using any database management tool
  • You can export all the data easier by exporting only one table
In order to achieve these goals, 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 to custom tables. It works with all field types of Meta Box plugin as well as all meta types (post, user, term). The extension uses a simple syntax to define table and you won’t have to change your meta box definition.

See how to save WordPress custom fields in custom tables

Features

  • Uses WordPress recommended method to create custom tables, which allows you to upgrade table structure anytime.
  • Provides a simple API to define table structure.
  • Works with any meta types: post meta, user meta, term meta, comment meta.
  • Provides an easy way to integrate with your existing meta boxes.

Related item support tickets

Here are public support requests that are related to this item. If you cannot find what you need, please hit Report error button.
No related request was found.

Why choosing GPL Coffee?

How to download meta box custom table addon 2.1.10

How to install meta box custom table addon 2.1.10

After click Download button above, you’ll get mb-custom-table-2.1.10.zip. Normally, you have to unzip mb-custom-table-2.1.10.zip, then find the installable sub-zip to upload to your server or your Wordpress admin area. But there are times you don’t have to do that if there is no sub-zip files inside mb-custom-table-2.1.10.zip, e.g there is only one folder inside mb-custom-table-2.1.10.zip.

Black Friday ultimate deal

Enjoy up to 50% off our packs.

(Discount is applied forever as long as the subscription is active)