Home Forums General Issues Meta Query request very slow Reply To: Meta Query request very slow

  • Thanks for your answer.

    It seems that it comes from this part :

                    '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 ^^