laptopspot Posted July 12, 2016 Share Posted July 12, 2016 Hi, Our prestashop store holds approx 150.000 products, and 70.000 categories. We have one language installed (dutch). When i look in our Mysql database, in the tables ps_category_lang ps_cms_lang ps_image_lang ps_meta_lang etc, lets say every table that has to do something with the languages, for each record i see 2 entry's. One for lang_id 1 and one for lang_id 2. Looks to me that it's costing performance and space. How to clean things up, and preventing this from happening? Link to comment Share on other sites More sharing options...
vekia Posted July 12, 2016 Share Posted July 12, 2016 do you use two languages in your shop or only one? Link to comment Share on other sites More sharing options...
laptopspot Posted July 12, 2016 Author Share Posted July 12, 2016 just one, that's why find this strange Link to comment Share on other sites More sharing options...
laptopspot Posted July 12, 2016 Author Share Posted July 12, 2016 i checked PS_lang and PS_lang_shop Also here just a single language listed. Link to comment Share on other sites More sharing options...
vekia Posted July 12, 2016 Share Posted July 12, 2016 so, if you use only one language, you can delete entries for language that you dont use and does not exist in your shop. I dont know if your shop uses some modifications / overrides, so it is worth to dump your database (backup) before you will remove these entries. deletion of ghost language entries SHOULD NOT AFFECT shop Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now