Hi, I am having problem with this simple MySQL query: select sender as id from message where status=1 and recipient=1 where sender table has multi millions of rows. When I run this on SequelPro, it runs really slow for the first time, ~4 seconds or more, and the next execution it run really fas…

MySQL query sometimes runs slow, sometimes fast

MrAwanish July 8, 2016, 12:03am 4

Try using MySql Table Partitioning features.

Topic		Replies	Views
Query slow first time, then fast Other MySQL® Questions	5	3998	February 8, 2008
Highly optimized queries are sometimes taking 20s to perform? Other MySQL® Questions	5	645	January 30, 2009
Query speed Other MySQL® Questions	2	377	January 12, 2007
Have to optimize every day ?! Other MySQL® Questions	2	423	March 13, 2009
Mysql join sometimes slow sometimes fast Other MySQL® Questions	0	574	March 17, 2018