Slow Bear
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 there,
our shop is growing. We have 5000 variations meanwhile, and most of them have approx 20 custom attributes/fields. The reaction latency of bear is horrible slow meanwhile lets say 5 sec for a search of 20 products in category"boot" with color"red".
The SQL query itself is bullet-fast. So where is the time lost?
This is essential question for us! Our staff is asking me for alternatives.
Best, Uwe
Just made a benchmark:
Directly querying the WordPress database in PMA: Showing rows 0 - 24 (1790 total, Query took 0.0244 seconds.)
SELECT * FROM wp_posts WHERE post_type = 'product' OR post_type = 'product_variation' AND post_status = 'publish' AND ID IN (SELECT post_id FROM wp_postmeta WHERE meta_key = 'Color32' AND meta_value = '#000000') ORDER BY post_title;
In Bear: 5 - 10 sec. for a first load, and 3,5 sec for Alt+S
Hello
Please paste your license key here - https://share.pluginus.net/image/i20210618130558.png -> https://share.pluginus.net/image/i20210618130614.png
It looks like most of the time is spent on drawing taxonomies. Do you have many taxonomy terms?
How much is many? Probably 2-4 categories and averaged 4 Tags per produkt + 10-20 custom attributes per variation.
Not that much i think.
Hello
no, I meant a few thousand
Can you drop me wp-admin access to check it - https://share.pluginus.net/image/i20210618130558.png ->https://share.pluginus.net/image/i20210618130637.png
Sorry, this not possible due to confidential customer and payment data. We have a clone to test new features, in near future, I can eventually clean all the confidential things and give you access there.
Best, Uwe
Ok! Great
Write to me if you have any questions