Deleting attributes to lighten my database

[wacommunication]

Hi,

I thought a week ago that removing some of the attributes from my database would solve my problem with my saving buttons. It did, but it brought a new one : the site was becoming really slow and stopped working this morning.

So i brought back my old ps_attribute and ps_attribute_lang tables with more than 100.000 attributes and my save and save and stay buttons are back to infinite turning state.

So i'm looking for an SQL query that would help me clean the attributes, and any related table, so that i could start working on my products again.

I'm a newbie, i might be taking the problem the wrong way, so i'm open to any suggestion to solve that problem.

Thanks a lot !

[musicmaster]

If you start emptying tables I would start with the four ps_product_attribute* tables. 

[wacommunication]

Thanks musicmaster.

Can i check if the product created has been ordered, is in a registerd client cart, or has just been created by a bot ?

[musicmaster]

You are asking a lot. Maybe you send spend some more time investigating yourself.

An ordered product can be found in the ps_order_detail table

In the ps_orders table you find an id_customer. If you look that up in the ps_customer table you will find that it contains an is_guest field