error 1104 on product search

[heinz2]

Hallo,
in my shop I'm using:
joomla 3.6.2
virtuemart 3.0.16

About 36000 products are in my shop.

In virtuemart-backend, whenever trying to search for a product I receive an error 1104:
"The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay SQL=SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id` FROM `#__virtuemart_products` as p INNER JOIN `#__virtuemart_products_en_gb` as l using (`virtuemart_product_id`) LEFT JOIN `#__virtuemart_product_categories` as pc ON p.`virtuem  ..."

Does anybody have a suggestion, how to fix this?

Thanks in advance.

[Studio 42]

I think, it's a SQL limited by your hosting plan.

[heinz2]

Thank you, I will check this with my provider.