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.