simple query much slower in MySQL 5.6 than in 5.0
3 tables, with FK between them.
SELECT COUNT(*) FROM personas p, pacientes pa, asig_cita a
WHERE a.fecha_cita BETWEEN '2014-01-01' AND '2014-2-28' AND p.apellido1='gomez' AND p.codtipo_doc=pa.codtipo_doc AND p.nrodoc=pa.nrodoc AND pa.codpacientes=a.codpacientes;
0.1s in 5.0, 16s in 5.6
both EXPAINs are exactly the same.
there's an index on "apellido1"
am I missing something?
thanks
Subject
Written By
Posted
simple query much slower in MySQL 5.6 than in 5.0
March 27, 2015 02:36PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.