[
http://opencast.jira.com/browse/MH-8638?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=29467#comment-29467
]
Christopher Brooks commented on MH-8638:
----------------------------------------
We have the default indices from 1.2 applied. An explain of the query
indicated indices are being used, but indexing isn't much of an issue given the
outer join in the original query.
As context for this, my tests were all on out mysql production server (5.1).
The problem seems to be that the job table is quite large, and the outer join
cross products this with service_registration table which creates a large
in-memory temporary table.
> Stats queries are much too slow
> -------------------------------
>
> Key: MH-8638
> URL: http://opencast.jira.com/browse/MH-8638
> Project: Matterhorn Project
> Issue Type: Bug
> Components: Administrative Tools
> Affects Versions: 1.2
> Reporter: Christopher Brooks
> Priority: Release Blocker
> Fix For: 1.4
>
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
http://opencast.jira.com/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
Matterhorn mailing list
[email protected]
http://lists.opencastproject.org/mailman/listinfo/matterhorn
To unsubscribe please email
[email protected]
_______________________________________________
