Thanks for your answer.
It seems that it comes from this part :
array(
'key' => 'prix',
'value' => $prix,
'type' => 'NUMERIC',
'compare' => '<='
),
Because when I comment this part, the search is faster. But I don’t know how to be more efficient than that…
Concerning the change from LIKE to =, I tried. But nothing appears when I’m using it. Is it possible to use = with CHAR ? Because it’s well stored as “Appartement”, “Maison” or “Local commercial” (and in the search, I have the capitalized word, so strictly the same as it’s stored in database).
In every case, I can’t ask my client to come back to all his products to update them, he will be mad ^^
