The problem: As soon as you have to generate more than 1000 variants in the Administration, it always terminates with the error message Serialization failure: 1213 Deadlock found when trying to get lock . The problem can be found via Google very often in relation to Shopware 6 also, that if you ever want to generate more than 1000-2000 variants, it constantly aborts because of a database error.

It would be great if you can outsource the variant generation in the message queue, so that you do not have to actively leave the page open for hours for 100k products.
Maybe it would also be a possibility to save the generation as a kind of "order" and then trigger it via the console.