On 2010-06-04 12:27, Tim Penhey wrote:

  * The queries to get the branch details using the primary key took averaged
just under 500ms each (WTF?)
> - a more detailed check shows most in the 3-11ms range, but two outliers:
> 2294ms and 639ms these two blowing the average somewhat.

I hadn't noticed the aggregation of identical queries under "long queries" before. Reporting an average there seems misleading: the average hides a real problem in what looks like a long-but-still-acceptable query time.

It's a good thing you looked further and discovered that the number was misleading. I don't think the "long queries" listing should aggregate identical queries. We have the "repeated queries" listing for that.


Jeroen

_______________________________________________
Mailing list: https://launchpad.net/~launchpad-dev
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~launchpad-dev
More help   : https://help.launchpad.net/ListHelp

Reply via email to