> From: Brandon Phelps <bphelps@stripped>
> 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.
You need an index on `close_dt`.
> INET_NTOA(src_address) AS src_address,
> INET_NTOA(dst_address) AS dst_address,
> FROM connections
> dst_port = 80
> ORDER BY close_dt DESC
> LIMIT 0, 30
Current farmers, who have become mere operators of machines and mixers of chemicals, may
not have the skills to develop a local, sustainable agriculture. A new generation of
farmers, numbering in the tens of millions, will need to be trained and relocated to rural
communities. -- Pat Murphy
:::: Jan Steinman, EcoReality Co-op ::::