in reply to Speed up DBD::MySQL Queries

I'm no expert in SQL, but can't you reduce it to 1 SQL statement?
SELECT sec.KEY, sec.ID, sec.HID, bt.NAME, bt.STATE, stats.CCS, stats.kbps, stats.MBytes FROM sec, bt, stats WHERE sec.ID = bt.id AND sec.HID = bt.HID AND sec.ID = stats.id AND sec.HID = stats.HID AND sec.INSTANCE = stats.INSTANCE ;

$\=~s;s*.*;q^|D9JYJ^^qq^\//\\\///^;ex;print