I am using the query below and variations of it to query a database with
a TON of records. Currently the database has around 11 million records
but it grows every day and should cap out at around 150 million.
I am curious if there is any way I can better optimize the below query,
as currently it takes this query around 10 seconds to run but I am sure
this will get slower and slower as the database grows.
INET_NTOA(src_address) AS src_address,
INET_NTOA(dst_address) AS dst_address,
dst_port = 80
ORDER BY close_dt DESC
LIMIT 0, 30
I do have an index on the dst_port column, as you can see by the output
Extra Using where; Using filesort
Thanks in advance,