Comment 6 for bug 1402237
Revision history for this message
| Graham Binns (gmb) wrote Re: [Bug 1402237] Re: Node event log queries are slow (over 1 second), but no way to clear node event log | #6 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
0e1f616
(Get the code!)
On 15 December 2014 at 15:04, Jason Hobbs <email address hidden> wrote:
> To be clear it's not 10,000 entries - it's 10,000 * 150.
Right, but for one node there's only ~10,000 entries. I'll run these
through a query analyser and see what comes up as a chokepoint.
For reference, Launchpad Bugs has 1.4 million entries, and in order to
cope with that we had to tune the queries, not start deleting data.
Though I think having some way of clearing event history is doubtless
a Good Thing, it's not the prime fix here. We shouldn't say "Oh, page
X is slow? Well, you need to delete things." That's the Windows way,
and it's ropey™.