deleting at ps_search_index query too slow

[fuegonju]

Hi all,

 

i'm inserting products at my prestashop website (1.6), actually i have about 83000. But the more products i insert the more slow it's the process. 

 

Actually an insert takes about 11 seconds. Analyzing Mysql i found this query that takes 9,3 in the inserting process:

 

 

DELETE FROM ps_search_index WHERE id_product IN (83734);

 

 

what can i do to reduce dramatically this?

 

Thank you in advance!

Edited September 25, 2014 by fuegonju (see edit history)