Hi all, The query to update job statistics is really slow, and seems to be bogging down our db server. It takes around 50 seconds to run, and is called every ten seconds or so if the admin window is open. I don't know the query/package very well, but adam and I were looking at db issues and came up with a slightly more optimized version (takes about a dozen seconds to run). Can someone vet it for me and see if it seems reasonable?
Discussion at http://opencast.jira.com/browse/MH-8638 Maybe Tobias? Ced? Chris -- Christopher Brooks, BSc, MSc ARIES Laboratory, University of Saskatchewan Web: http://www.cs.usask.ca/~cab938 Phone: 1.306.966.1442 Mail: Advanced Research in Intelligent Educational Systems Laboratory Department of Computer Science University of Saskatchewan 176 Thorvaldson Building 110 Science Place Saskatoon, SK S7N 5C9 _______________________________________________ Matterhorn mailing list [email protected] http://lists.opencastproject.org/mailman/listinfo/matterhorn To unsubscribe please email [email protected] _______________________________________________
