How to speed up filtered woof result? + smartphone issues...
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 me again,
As I see Pablo is able to answered and fix all my question here is the next one:
- I have a very large catalog about 6000 products with variations.
- After clicking on"filter" button, sometime it can take ages to get the result...! average is 10 to 30 secondes!! and sometime to display 4 products..
- example: just go here https://www.billykite.com/product-category/kitesurf-title/kitesurf/ and just check box anything and click"filter".
- 30 secondes later.... we have a result
ISSUE number 2:
============
when using my phone or my tablet. sometime the checkbox doesn't want to check... like the screen is not responding.
example: Go here and select some boots sizes with your phone https://www.billykite.com/product-category/wakeboard/boots-wake/
sometimes the check boxe got check very delayed.
Any idea? it's really crazy...
Thank you for your support,
Jérôme
Hello Jérôme
- Read this please -https://products-filter.com/searching-is-slow/
- Try to check this option - https://c2n.me/42E68Js.png - to test
Hi Pablo,
thanks for your quick reply, after reading and asking different people:
I read that:
https://woocommerce.wordpress.com/2019/04/01/performance-improvements-in-3-6/
Then that:
https://github.com/woocommerce/woocommerce-product-tables-feature-plugin
and very sad that last commit was 29th of January 2019...
I also runned mysqltuner on my server and the main focus should be on:
==>" Adjust your join queries to always utilize indexes"
Is this talking to you? because I have no idea how to realize that on my server or on commerce.
below a sql request which take more than 15sec to be executed:
SELECT table_posts.ID
FROM table_posts
LEFT JOIN table_term_relationships
ON (table_posts.ID = table_term_relationships.object_id)
LEFT JOIN table_term_relationships AS tt1
ON (table_posts.ID = tt1.object_id)
LEFT JOIN table_term_relationships AS tt2
ON (table_posts.ID = tt2.object_id)
WHERE 1=1
AND ( table_term_relationships.term_taxonomy_id IN (2752,2760,2761,2762,2763,2769,2921,2930,8660,8661,8886)
AND tt1.term_taxonomy_id IN (8668,8670,8671)
AND tt2.term_taxonomy_id IN (7395)
AND table_posts.ID NOT IN (
SELECT object_id
FROM table_term_relationships
WHERE term_taxonomy_id IN (6) ) )
AND table_posts.post_type = 'product'
AND ((table_posts.post_status = 'publish'))
AND ID NOT IN (SELECT post_id
FROM table_postmeta
WHERE meta_key = '_pos_visibility'
AND meta_value = 'pos_only')
GROUP BY table_posts.ID
ORDER BY table_posts.post_date DESC
is your plugin would be able to use indexes or a lookup table?
thanks for your feedback,
Jerome
As well, one of my friend noticed on the sql request here above that this request doesn't include "indexation" option when creating the request.
Is this information talking to you? is it something which should be update in woof code? or activated in my sql server?
kind regards,
Jérôme
Hello Jérôme
My plugin does not make direct queries to the database! We use wordpress functionality.
the sql request here above that this request doesn't include "indexation" - ?????? - Please read docs - https://www.w3schools.com/sql/sql_create_index.asp
All these settings are not related to my plugin
The new version will be an extension to speed up the filter.
Hi Pablo,
I don't really know what I'm talking about, it's out of my skills. I just try to understand why it is slow and how can I speed up things by changing plugin settings or understand if problem is deeper.
I think problem is deeper and coming from woocommerce/wordpress.
I currently have around 6000 products and most of them have variations. Current filtering speed make it unusable for public release as customer will leave the page before query result.
On big webshop, filtering plugin is the key to success.
I don't know what to do you in order to make it usable. Do you have some details about your extension speedup plugin?
From what I understand filtering needs to look into wp_post and wp_postmeta and since 3.6 they designed lookup table in order to accelerate process. Still it's very slow for some queries on my webshop and your plugin is following the standard woocommerce call in order to get filtered result.
your help is warmly welcome.
Kind regards,
Jérôme
Hello Jérôme
https://products-filter.com/searching-is-slow/ - That's all I can offer on my part.
You can try my cache - plugin settings->Advanced->Options - https://c2n.me/42L80l6.png
to make tests - Please log-out
I think problem is deeper and coming from woocommerce/wordpress. - Yes, the database structure does not work well with search. But this is a fee for universality (flexibility)
The number of taxonomies is most influenced by the filtration speed.
It also depends on your hosting.
We are developing a new version of the plugin. In this version there will be an extension to speed up the filter.
Hello,
finally I changed filter plugin and I went from 30 sec to 2 sec filtered result for the same test.
I wish you success with the new version,
Jérôme
Hello Jérôme
Thank you!