Comment 47 for bug 1918145
Revision history for this message
| Sahid Orentino (sahid-ferdjaoui) wrote | #47 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
1b1ed1a
(Get the code!)
I think one of the first step that we can have is to remove the ORDER BY as it creates the temporary filesort that you have mentioned in #9.
I may missing something, an order by UUID does not bring any kind value?
A second step would be to understand why the possible key object_id is not used.
There is also another point, we can notice that we do filter per action, but I think that we do not have an index on it, maybe we could also investigate that point.