Optimize MYSQL query (very slow records)


good afternoon, I would like to know if you could help me optimize my query. Since in regularly large tables of more than 1000 records it is taking a long time to list the results. My query is as follows:

$q_juegos = mysql_query("SELECT * FROM juegos WHERE status=1 and cat_id = 1 and liga_id='2' and fecha = curdate()");

I greatly appreciate the help you can give me.

asked by Carlos Maldonado 16.11.2018 в 17:29

0 answers