Comment 12 for bug 641338

Revision history for this message
Julian Edwards (julian-edwards) wrote : Re: [Bug 641338] Re: timeouts too low for security unembargo

On Monday 20 September 2010 01:51:32 Robert Collins wrote:
> And in the previous bug, its death by a thousand cuts:
>
>
> SQL time: 15597 ms
> Non-sql time: 4683 ms
> Total time: 20280 ms
> Statement Count: 1661
>
> It should be < 50; package size isn't related - we don't actually copy
> content around AIUI, so this is basically just inefficient code.
>
> Lets get it efficient, and then think about long term. I don't see any
> reason why an efficient API shouldn't be able to do the unembargo in <
> 500ms.

The main reason is that the copy checker has to do a LOT of work. It issues a
lot of queries.

I would look at how to make that better first.

lib/lp/soyuz/scripts/packagecopier.py