Comment 3 for bug 474876

On Thu Nov 05 08:57:27 UTC 2009 Julian Edwards wrote:
> Hmm that getChangesFilesForSources() code should be a very quick query.
> Is it timing out a lot or is it sometimes quick? I have a suspicion
> that it can use a slave store rather than the main store, which might
> improve things.

It's not always timing out.

The OOPS I posted shows 74 repeated queries for a window of 75, with a
couple of long ones. It appears that doing the queries 75 times can
sometimes hit some DB contention, and so push the overall time over the
timeout threshold.

Thanks,

James