MySQL query takes too long in codeigniter

1 vote

1 answer

1094 views

                          I've made this query 

    SELECT id,name,iupac_name,inchi_key,molecular_weight,molecular_formula,exact_molecular_mass
    	FROM compound
    	WHERE name LIKE '%quer%'
    	OR iupac_name LIKE '%quer%'
    	OR inchi_key LIKE '%quer%'
    	OR inchi_key IN( SELECT inchi_key FROM compound_synonyms WHERE name LIKE '%quer%')

that took 0.3563 seconds to show result through phpmyadmin in my local machine and took 0.1117 seconds in digital ocean vps.

But the same query took 24+ minutes in another vps.

Does anyone can help me to find out the problem?
                        

Asked by morshed (111 rep)

Jul 21, 2019, 05:03 AM
Last activity: Dec 19, 2022, 06:00 AM

MySQL query takes too long in codeigniter

Related Questions