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 Officer Infrastructure Services | ENG1 E1-1-08 University Of Sussex, Brighton EXT:01273 873900 | INT: 3900