[Monotone-devel] Re: [PATCH 1/2] git_export: avoid multiple sql queries

[Felipe Contreras]

On Mon, Mar 9, 2009 at 5:41 AM, Derek Scherger <address@hidden> wrote:
> On Sat, Mar 7, 2009 at 11:31 PM, Felipe Contreras
> <address@hidden> wrote:
>>
>> This improves performance while exporting. In my system I see an
>> improvement from 52 minutes to 6 seconds.
>
> Committed in rev 0d53349ddb2728ddf1342cdfe69810840bef5252. I've also done
> something similar to the log command and this made a *huge* difference. On
> my laptop logging net.venge.monotone back to the root took around 9 minutes.
> With this change it takes around 4 seconds.
>
> The problem that this has uncovered seems to be that the query for certs by
> revision id and name uses the unique index on revision_certs which isn't the
> one we want. Querying without the name uses the revision id index which
> seems to be much better.
>
> Thanks Felipe!

Awesome! I always thought mtn log was *sloow*, not any more thanks to you :)

-- 
Felipe Contreras