Improve performance of user queries by adding a new table.
Contributors: spacedmonkey Donate link: https://example.com/ Tags: comments, spam Requires at least: 5.2 Tested up to: 5.2 Requires PHP: 5.6.0 Stable tag: 1.0.0 License: GPLv2 or later License URI: https://www.gnu.org/licenses/gpl-2.0.html
Improve performance of user queries by adding a new table.
This plugin is designed to improve performance of role based user queries. Roles are stored in user meta table, in an array. To query by role, requires a LIKE search on user meta table. For large sites or multisite, with lots of users, this can make queries take a long to return.
The plugin adds a new table that makes querying by user, a much simplier query, reducing database stain.
This plugin requires WordPress 5.2. Is designed to work with multisite. It is required it should be installed as an mu-plugin.
For this interested in user query performance, you may wish to also install the WP User Query Cache plugin.
wp-user-roles.zip
from your computerwp-user-roles.zip
wp-user-roles
directory to your computerwp-user-roles
directory to the /wp-content/plugins/
directoryThe WP User Roles includes native support for the GitHub Updater which allows you to provide updates to your WordPress plugin from GitHub.
Yes, this it is not needed