MySQL query, 2 similar servers, 2 minute difference in execution times
- by mr12086
I had a similar question on stack overflow, but it seems to be more server/mysql setup related than coding.
The queries below all execute instantly on our development server where as they can take upto 2 minutes 20 seconds.
The query execution time seems to be affected by home ambiguous the LIKE string's are. If they closely match a country that…