Timeout when having too many declinations

[robrob]

Hey there, I'd like to report what I think is a bug.

We're working on a webshop that contains about 10K products.

Products have between 1 and 20 declinations each.

We're currently importing the declinations via csv import, but the thing is that it gradually breaks the back office features. Each of our import files adds about 2500 declinations, and when we do so, displaying the product edit tabs take a bit more time to display. At some point, opening the product edit page gets timeout (save buttons keep loading and a timeout popup appears).

Setting a high limit for script execution and no memory limit doesn't seem to help. We've got several backups of the db, and we can easily identify that adding more declinations after a certain limit completely breaks the back office.

Prestashop version : 1.6.1.18

PHP : 5.6

Any ideas ?