45354 Adds composite index to postmeta table#10987
45354 Adds composite index to postmeta table#10987nimesh-xecurify wants to merge 2 commits intoWordPress:trunkfrom
Conversation
Improves performance for common meta queries by introducing a composite index on `meta_key` and `post_id` in the `postmeta` table. Ensures the index is added during new installations via the schema definition and through an upgrade routine for existing sites. Includes new tests to verify the schema update and the upgrade path.
|
The following accounts have interacted with this PR and/or linked issues. I will continue to update these lists as activity occurs. You can also manually ask me to refresh this list by adding the Core Committers: Use this line as a base for the props when committing in SVN: To understand the WordPress project's expectations around crediting contributors, please review the Contributor Attribution page in the Core Handbook. |
Test using WordPress PlaygroundThe changes in this pull request can previewed and tested using a WordPress Playground instance. WordPress Playground is an experimental project that creates a full WordPress instance entirely within the browser. Some things to be aware of
For more details about these limitations and more, check out the Limitations page in the WordPress Playground documentation. |
Improves performance for common meta queries by introducing a composite index on
meta_keyandpost_idin thepostmetatable.Ensures the index is added during new installations via the schema definition and through an upgrade routine for existing sites. Includes new tests to verify the schema update and the upgrade path.
Trac ticket: https://core.trac.wordpress.org/ticket/45354
Use of AI Tools