@Firvulag its actually better to do more processing in PERL than with a "perfect" SQL query sometimes.
For mysql, creating a large temporary table on disk can slow things down until you get a query backlog (which is usually followed by a crash in short order). That is something I see a lot in my line of work.
For mysql, creating a large temporary table on disk can slow things down until you get a query backlog (which is usually followed by a crash in short order). That is something I see a lot in my line of work.