Re: [Banshee-List] optimization research

[Ruben Vermeersch <ruben savanne be>]

On Fri, 2009-12-11 at 22:00 -0800, Gabriel Burt wrote:
> ms    calls   class_and_method
> ----  ------  ---------------------------------------------------------------------------------------------
> 1949  313     Hyena.Data.Sqlite.HyenaSqliteCommand:WaitForResult
>
> So 1.9s was spent waiting for sqlite commands to return values, on the
> main thread. 

So on average this means that each query takes 6.2 ms to execute, if we
assume a uniform distribution. Obviously, this won't be the case and we
can probably expect some outliers.

It would be nice to see the distribution of these wait times and if
possible the query that caused this wait, it'll most probably lead you
towards a slow query path (and thus an good optimization target).

   Ruben