sql repeat command

[tanasus]

Hello all,
im using Joomla! 3.9.1 and VM 3.4.2.
I see at my sql the command

Code Select Expand

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 ?

[SimonHodgkiss]

Hello,

I have this issue as well now!

Anyone know how to fix?

Joomla 3.9.10 and virtuemart 3.4.2

Thanks

[StefanSTS]

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