Tips to increase speed for feed generation

Shopware 6 (English)
1

Hi Guys,

I am working on a shop with more around 300000 products, and I am migrating it to shopware 6. We have a very long conditions for feed generation. Multiple categories, manufacturers to ignore, some other conditions as well. So feed generation looks very slow to me. But in the live server (sw5), it finishes faster. Any tips and tricks to make it run quicker?

Am I the only one feel this?

Also I have complex condition like this in shopware 5,
(coalesce(d.releasedate, current_date()) <= DATE_ADD(current_date(), interval 10 day) or d.instock > 0)

how can I add it to the shopware 6 rule builder?

All solutions are welcome.

2

Deactivate indexing while importing data. That will speed up things.

You can write your own rules with a plugin. Then you can select them.

Be warned that too many rules (e.g. >1000) might slow down your system if they are complex, since they are all evaluated with almost each request.

You find all these in developer.shopware.com

3

Thanks for the reply.

But why should we need to deactivate indexing while importing data? What is the logic/reason here?

4

Sorry, I had importing data in mind, when I wrote that comment. I guess I confused that when reading something about migration.

Indexing has nothing to do with feed generation.