Hi,
We're having trouble on several sites, where importing 500k-1m EcomProductCategoryFieldValue will lock up the website for several minutes.
After some mucking about, I've found out that the problem is the foreign key constraints on theEcomProductCategoryFieldValue table.
Apart from the obivous risk that we'll import invalid data, do anyone see a big risk in removing the constraints?
I assume the constraints are checked in code before data is saved to the database, when editing products in the backend, right?
Regards, Jonas