RFC 2866 - Accounting ON / Accounting OFF packets

[Arran Cudbard-Bell]

Alan DeKok wrote:
> Arran Cudbard-Bell wrote:
>   
>> What was the problem with SQL relay in 2.02 ?
>>     
>
>   There wasn't a problem with that, but with reading the "detail" files.
>  It's fixed in CVS head.
>
>   The fault was complicated... it's a lot better now. :)
>   
Good to hear :)

Could you commit that minor change to the MySQL schema.

MySQL 5 doesn't require compound indexes, as of 5 it can use multiple 
indexes for the same query.

http://dev.mysql.com/doc/refman/5.0/en/index-merge-optimization.html

So adding an index on acctsessiontime should fix the problem.

Thanks,
Arran

-- 
Arran Cudbard-Bell (A.Cudbard-Bell at sussex.ac.uk)
Authentication, Authorisation and Accounting Officer
Infrastructure Services | ENG1 E1-1-08 
University Of Sussex, Brighton
EXT:01273 873900 | INT: 3900