Hey all, I hope someone can shine some light on this... Prestashop is awesome! It loads fast on the front end and im very pleased with its performance with regards to the customers point of view, but im in a situation where if i start to use the back office the front end slows down massively, and the back office can and does comes to a stand still... Now It only happens when I want to edit or update a product, just so you get an idea on the size of the products attributes that im currently running for all of our product together. Table name : product_attribute Keyname Type Cardinality (records) PRIMARY PRIMARY 121,012 Table name : product_attribute_combination Keyname Type Cardinality (records) PRIMARY PRIMARY 543,890 Now I've not had any issues with this until this week, and now what happens is the product admin pages load but some how get into a loop and cause the MySQL server to stall with processes running for ages. Is there anyway I can get some sort of indexing working on the product_attribute_combination table to increase the speed of the Back Office, The combinations are causing the entine product page to now not load at all in the back office. Any advice, even if its only basic is appreciated, as i need to be able to update these products even if it means the combinations are updated seperately. Kind Regards Dan.