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
om MySQL's website. Perhaps I would try compiling from source?
Mike
-Original Message-
From: Michael Shuler [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 21, 2003 4:41 PM
To: [EMAIL PROTECTED]
Subject: Very Slow GROUP BY Query
I have been trying to understand why this query is
I have been trying to understand why this query is taking over 60 seconds to
complete SOMETIMES...its not that complicated and the server (4.0.17) is
under very little load. Any help would be appreciated.
They Query:
SELECT Realm, COUNT(*) AS CallCount, SUM(AcctSessionTime) AS RealmTime FROM
Ser
