Multishop and Languages

[aboji]

Hello,

 

I'm dealing with a shop with more than 50k+ products that have multishop enabled and have one shop per language.

 

So shop 1 only has language 1 enabled.

Shop 2 only has language 2 enabled.

Shop 3 only has language 3 enabled and so on.

 

The issue is that even though shop 1 only has language 1 enabled, language 2,3,4 and so on is still stored for this shop in the product_lang table in database and now this table is multiple GB in size and slowing down the site. Since shop 1 only has language 1 enabled the other languages for shop 1 is just using unnecessary database resources.

 

Any ideas on how to solve this? Is it safe to just remove all records in database table where shop = 1 and language != 1, shop = 2 and language != 2 and so on? What would the SQL query be and how do we prevent Prestashop from re-adding to the database when updating products?