ql> Alter table ServiceRADIUSAccounting add index idx_realm(Realm);
That should optimise the where clause quite a bit.
Cheers,
Andrew
-Original Message-
From: Michael Shuler [mailto:[EMAIL PROTECTED]
Sent: Sunday 21 December 2003 23:28
To: [EMAIL PROTECTED]
Subject: RE: Very Slow GROUP BY
A little extra info... MySQL's process list says:
Command Time Status SQL-Query (which looks like it
abbreviates)
Query 67 Sending data SELECT Realm, COUNT( * ) AS CallCount, SUM(
AcctSessionTime ) AS RealmTime FROM ServiceRADIUSAccounting
Thinking this could be a netwo