[RFC PATCH] 3x improvement in patch listing

[Daniel Axtens]

Konstantin Ryabitsev <konstantin at linuxfoundation.org> writes:

> On Wed, Aug 08, 2018 at 05:40:06PM +1000, Stewart Smith wrote:
>>There's two main bits that are really expensive when composing the list
>>of patches for a project: the query getting the list, and the query
>>finding the series for each patch.
>
> Stewart:
>
> Thanks for working on this! Do you think this would help with pagination 
> as well? I find that in semi-abandoned projects like 
> https://patchwork.kernel.org/project/qemu-devel/list/ it takes a few 
> seconds to load the list view due to 800+ pages of unprocessed patches.  
> I am currently considering an automated script that would auto-archive 
> patches older than 6 months, but if simply improving pagination times 
> would fix the issue, then I wouldn't need to bother.

It should do. From a brief look at his patch, it fixes a hot path in
__init__.py that goes through the paginator (and which I was *sure* I
had looked at, but apparently I had not!) I'll do a quick sanity check
on it and hopefully apply it to master and stable/2.1 within the next
few days. (but no promises!)

Regards,
Daniel

>
> Best,
> -K
> _______________________________________________
> Patchwork mailing list
> Patchwork at lists.ozlabs.org
> https://lists.ozlabs.org/listinfo/patchwork