User Role Tables

User Role Tables for WPUserQuery A lightweight and efficient WordPress plugin that mirrors user roles into a custom database table to optimize performance for WPUserQuery and getusers() calls. By offloading role-based queries to a dedicated table, this plugin reduces database overhead, making large-scale user management faster and more reliable. Installation Install and activate the plugin. This should automatically install the database table: wpuserroles. Run the following command to copy all user role data to the new wpuserroles table: This command will extract all users roles and capabilities from wppostmeta, and insert this data is a more performant schema in the wpuserroles database table. Running Unit Tests To ensure the plugin works as expected, you can run the included unit tests. Follow the steps below: Prerequisites - Make sure you have Docker installed and running on your machine (required for wp-env). - Ensure you have Composer installed to manage PHP dependencies. Steps to Run Tests 1. Start the WordPress Environment: Use wp-env to spin up a local WordPress environment: bash composer install 3. Run the Tests: Execute the Composer test script to