Empty Meta Cleanup for WP Job Manager

Description

Anytime WP Job Manager or related plugins (WP Job Manager Resumes, Cariera (Companies), Company Manager, Astoundify Company Listings, and MAS Company Manager) saves a listing, it does so for every field configured, even if there is no value to be saved.

This can result in a large amount of empty meta values stored in the database, ultimately causing slower query times, a larger database, and issues with querying for listings based on meta values (when using Search and Filtering for WP Job Manager).

Configuration can be found under the “Meta” tab in the associated Settings page (Job, Resume, or Companies).

You can contribute to this project on GitHub:
https://github.com/tripflex/wp-job-manager-empty-meta-cleanup

It’s also STRONGLY recommended that you also install the Index WP MySQL for Speed plugin
https://www.ads-software.com/plugins/index-wp-mysql-for-speed/

Screenshots

FAQ

How do I cleanup existing empty meta?

To cleanup existing empty meta entries in the database, you must be have either the WP Job Manager Field Editor 1.12.2+ or Search and Filtering for WP Job Manager 1.1.9+ plugin installed and activated. The code that handles that is included in those plugins, and is not something included with this plugin.

Do I really need this?

It depends. Does your theme or another plugin add custom fields outside the default WP Job Manager (or associated) fields? Have you changed any of the fields to optional? Are you
using the WP Job Manager Field Editor or Search and Filtering for WP Job Manager addons? If you answered yes to any of these, then yes.

How does it work?

Currently the method used to handle this is by looping through all the fields after the core plugin saves the listing, checking if those values were actually submitted when the
listing was saved, and if they are not, it deletes the meta from the database. In an upcoming release the core plugins will be short-circuited when they attempt to save the meta,
but for now we just delete the empty meta value after it’s added to the database.

Can I exclude specific fields?

Yes you can, please check GitHub project for associated filters that can be used (a UI will be added in a later release for this)

How else can I speed up my site and database?

I strongly recommend also using the “Index WP MySQL for Speed” plugin to add indexes to your database:
https://www.ads-software.com/plugins/index-wp-mysql-for-speed/

Reviews

Contributors & Developers

Changelog

1.0.5

Fixed support for Company Fields in Cariera 1.7.2+

1.0.4

Added support for Cariera 1.7.2+

1.0.2

Omit custom repeatable fields when saved from admin area

1.0.1

Fix incorrect option check on frontend removal

1.0.0

Initial Release