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?
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.