RFC 2866 - Accounting ON / Accounting OFF packets

[Ivan Kalik]

AcctSessionTime is not indexed in default 1.1.6 or 1.1.7  mysql schema
either.

Ivan Kalik
Kalik Informatika ISP


Dana 13/3/2008, "Phil Mayers" <p.mayers at imperial.ac.uk> piše:

>> Also the index 'acctsessiontime' is missing for the radacct table in the
>> default schema; makes the Accounting-On / Accounting-Off queries very
>> slow doing a table scan on 1.4 million rows... Is this intentional or an
>> oversight ?
>
>In the postgres schema, there's a conditional compound index which makes
>that query fast/indexed, so I suspect it's an oversight.
>-
>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>
>