Create Multiple Variation Limit for each item?

I was creating multiple variations for an Item, and i reached around 2000, now it is being way slower and giving an error when i generate 360 more. Is there a limit of variations per item?

I already tried to optimize the configs of MySQL and etc. Is this behavior normal?

I’m running v15

Hi @Smooth_Play,

At a time you can 500 variants you can create. please check it.

Hello, thank you for the info. But what i mean is that i can do that in the begging when the database has no items, but when i have already inserted 2000 variations of the same item it starts to get slower and throw errors.

So basically, first i can do 500, then 300, then 150… As the database gets bigger it gets more and more difficult, if not impossible to run the job. My timeout is 300 secs.

Is it normal?

Yes @Smooth_Play

In this situation what would be recommended? Increasing max timeout is just a temporary solution right?

I already tried to optimize innodb and workers, but it had no effect on this issue.

I wonder also if it will be the same if I do variations for other items i have to test it out. (i started just by one item with lots of variations)