Performance Codeigniter, + 2 million records.

Run your query in phpMyAdmin and use the explain command to see if it will speed it up.



Good morning, I put this query in phpMyAdmin: EXPLAIN SELECT * FROM listeners WHERE updatedAt> = '2021-08-01 00:00:00' AND updatedAt <= '2021-08-12 23:59:59' AND connecttime> = 10

Returned the attached print, the return was instantaneous.