[Luca Tocco]

Yes i have a lot of products but the problem is that that query start every time i load every page in the wordpress dashboard(also the one not related with your plugin) and this is not good at all.
If you need it for some plugin option you need to execute that query only in the page it belong (and also this way it can really slowdown the plugin option if there’s a lot of data).
Thanks for your attention and waiting for the filter in the next update. As soon as it’s out i let you know if it works properly.

[Luca Tocco]

We found a way to fix it with a workaround. The problem was that the plugin has a query that call all the products on each page (and there’s no reason to do that..).
So in woocommerce-catalog-enquiry-core-functions.php we changed the post per page value from -1 to 12 and now it works (see code below).

// find all woocommerce product
if(!function_exists(‘woocommerce_catalog_products’)) {

function woocommerce_catalog_products() {
$args = array( ‘posts_per_page’ => 12, ‘post_type’ => ‘product’, ‘post_status’ => ‘publish’, ‘orderby’ => ‘title’, ‘order’ => ‘ASC’ );
$woocommerce_product = get_posts( $args );
$all_products = array();
foreach ( $woocommerce_product as $post => $value ){
$all_products[$value->ID] = $value->post_title;
}
return $all_products;
}
}

BTW i think it’s a bug and your tech department need to look at it and find out if that call is needed or not..and maybe use a cron to call that query only where needed.

Hope this will be fixed in a future release.
Best.

[Luca Tocco]

I’ve followed your instruction and the problem is still there. I’ve tried on a website with under 100 products and there’s no problem, the problem start when you have a great amount of products (in my case 1500).In the screenshot you can see the exact query. The really strange thing it’s that it happen everywhere in frontend and backend (also in pages not related to your plugin).

[Luca Tocco]

Same problem here.
I’m using the plugin from november and it was not this way.

[Luca Tocco]

I’ve already used an editor role with no luck so any reference on hook/filter can be great.
Thanks!

[Luca Tocco]

Thanks! Waiting for the update at one point.

[Luca Tocco]

It’s not a query but a quiet simple improvement for future release.
You have a contact form builder in the pro version of Enquiry form and i think a lot of peoples a system with precompiled dropdown country.
https://www.technicalkeeda.com/index.php/html-tutorials/all-countries-drop-down-list-in-html
You can check WpForms predefinied block and do something similar, they have Country and Nation and other useful precompiled block.Check this link: https://wpforms.com/how-to-country-dropdown-list/
Best.

[Luca Tocco]

It’s not a query but a quiet simple improvement for future release.
You have a contact form builder in the pro version of Enquiry form and i think a lot of peoples a system with precompiled dropdown country.
You can check WpForms predefinied block and do something similar, they have Country and Nation and other useful precompiled block.Check this link: https://wpforms.com/how-to-country-dropdown-list/
Best.

[Author]

Posts