Hello all,
im using Joomla! 3.9.1 and VM 3.4.2.
I see at my sql the command SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id` FROM `nfojm_virtuemart_products` as p L
run continuously and this cause me high sql cpu problem...
I think it is a bug...
Any help ?
Hello,
I have this issue as well now!
Anyone know how to fix?
Joomla 3.9.10 and virtuemart 3.4.2
Thanks
Hi,
high sql cpu usage in VM 3.4.2 might come from
1. enabling the setting "Virtuemart 404 handling", that should be switched off in VM config -> tab Shop.
2. Another possible issue in Vm Config -> Templates -> tab Shopfront settings. Set all "Omit" to "No".
You might want to test VM 3.5.0.10098 on a test environment, I guess it should be solved there.
Regards
Stefan