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@sussex.ac.uk) Authentication, Authorisation and Accounting OfficerInfrastructure Services | ENG1 E1-1-08 University Of Sussex, Brighton
EXT:01273 873900 | INT: 3900