index-wp-mysql-for-speed
index-wp-mysql-for-speed copied to clipboard
OllieJones
taxonomy indexing
From a user:
Would it be possible to add keys for an eCommerce Store that has product filtering with lots of attributes?
wp_terms wp_term_taxonomy wp_term_relationships wp_woocommerce_termmeta wp_woocommerce_attribute_taxonomies (for product attributes)
We have a website with lots of attributes and performance is too slow when doing product filtering on a category page.
Can they provide the generated SQL? Rick Jamesemail: @.***
On Tuesday, February 8, 2022, 05:53:33 AM PST, Oliver Jones ***@***.***> wrote:
From a user:
Would it be possible to add keys for an eCommerce Store that has product filtering with lots of attributes?
wp_terms wp_term_taxonomy wp_term_relationships wp_woocommerce_termmeta wp_woocommerce_attribute_taxonomies (for product attributes)
We have a website with lots of attributes and performance is too slow when doing product filtering on a category page.
— Reply to this email directly, view it on GitHub, or unsubscribe. Triage notifications on the go with GitHub Mobile for iOS or Android. You are receiving this because you are subscribed to this thread.Message ID: @.***>
I asked the user to capture a monitor from within the plugin, but they haven't gotten back to me.
I've been fooling around with the taxonomy / term / relationships system myself in a test WooCommerce store. The queries themselves are OK, and use existing indexes, but the Woo Commerce app code does ~~dumb~~ suboptimal things like SELECT * then counting the rows to get a result set count. It needs refactoring big time.
Hi @OllieJones! I just installed your plugin in my demo/dev environment and will provide you with my own monitor logs.
monitor ‹ Index WP MySQL For Speed ‹ Femme Fatale — WordPress.csv Here is the log. The development site is here: https://botiga.ecode.gr/wp/
What I did was to follow all the main menu categories (a couple have up to 3000 products), then try the filters (on the left side bar), then a product, cart, favourites... Then I went to the Products admin panel, edited a product and also tried search (powered by SearchWP).
I hope this helps.