Extremelly slow price filter query
The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday. If you have problems with registration ask help on contact us page pleaseIf you not got email within 24~36 business hours, firstly check your spam box, and if no any email from the support there - back to the forum and read answer here. DO NOT ANSWER ON EMAILS [noreply@pluginus.net] FROM THE FORUM!! Emails are just for your info, all answers should be published only here.
The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday.
Hi, i am having an issue with a category that has 6500 product. The query for price filter takes around 40s to load. Is this how it is supposed to work? Is there a workaround to make it load faster? This specific category take for ever to load. I activated turbo mode just in case it would do the magic without much luck.
Hello
Please drop me exact link to the issue
Read this - https://products-filter.com/searching-is-slow
This is the URL:
https://caraudiotech.gr/product-category/oem-multimedia-screen/
Hello
Please update the plugin to latest version - https://products-filter.com/how-to-make-auto-update-for-wordpress-plugins-and-themes-bought-on-envato
Check option - https://share.pluginus.net/image/i20230504113136.png
It is still really slow, updating did not do the trick. There is this SQL query that are taking up to 40s to be executed and it is loaded twice:
SELECT min( FLOOR( price_meta.meta_value + 0.0) ) as min_price, max( CEILING( price_meta.meta_value + 0.0) )as max_price
I am trying the Reassemble products data option for turbo mode to see if it can impove anything.
Please drop me wp-admin access - https://share.pluginus.net/image/i20230222134241.png ->https://share.pluginus.net/image/i20230222134615.png
I updated the private data with the website credentials. Thanks!
Your link - https://c2n.me/4is1AWB.png
Update on the situation, checking the logs i noticed some weird interaction with Gutemberg blocks and payment method bacs not registering, installing this plugin seems to fix the issue
https://woocommerce.com/products/woocommerce-gutenberg-products-block/
Hello
that is, installing this third-party plugin removes queries in the database. did I understand you correctly?
It did not remove queries, for some reason it was looking for some woocommerce depencies that were not there. Installing this fixed my problem (these queries are not 40s long any more), i guess this issue had nothing to do with your plugin.
Ok! Great! Than you for info!