Quazz

I recently upraded MariaDB to 10.4 (as it is supported by Magento 2.4.1) and found I had to disable an optimizer_switch or indexation would be very slow when part of...

There's also this: https://github.com/magento/magento2/pull/27129 to consider and potentially patch here. Improves index times even further.

@romainruaud Thank you for those. I believe 'optimize_join_buffer_size=on' is default from 10.4.3 onwards now.

About 15-25% improvement (for the full catalogsearch reindex) on a 125K ish catalog with 3 store views in a quick test. Can't fully speak to whether the results are the...

For your first problem, I don't remember exactly, but I seem to recall this being a Magento core bug. The second one was a problem I used to struggle with...

> Hi @Quazz Thanks a lot for your reply > > Regarding my first issue, it was due to less heap size on elasticsearch server, we extended it from 4...

Is there a way to determine what the cause is? It seems like ->getVirtualRule() is returning a string when an object is expected.

After commenting out line 116 in Preview.php I am now manually saving categories that don't have is_virtual attribute, found by query: `SELECT entity_id FROM catalog_category_entity WHERE NOT EXISTS (SELECT *...

Manually adding a check to verify if the virtualrule is an object and if not to exectute the ReadHandler seems to resolve it for me. ` if (!is_object($virtualRule)) { $this->virtualRuleReadHandler->execute($category);...

Yes, the weird thing is that it was working fine before and then suddenly it wasn't anymore. I see that the readhandler is supposed to be applied in the ResourceModel....