Re: [PATCH 05/11] Add covering index for /list/ query

2018-09-09 Thread Stewart Smith
Stephen Finucane writes: > On Fri, 2018-08-10 at 18:01 +1000, Stewart Smith wrote: >> In constructing the list of patches for a project, there are two >> main queries that are executed: >> 1) get a count() of how many patches there are >> 2) Get the page of results being displayed >> >> In a

Re: [PATCH 05/11] Add covering index for /list/ query

2018-08-31 Thread Stephen Finucane
On Fri, 2018-08-10 at 18:01 +1000, Stewart Smith wrote: > In constructing the list of patches for a project, there are two > main queries that are executed: > 1) get a count() of how many patches there are > 2) Get the page of results being displayed > > In a test dataset of ~11500 LKML patches

[PATCH 05/11] Add covering index for /list/ query

2018-08-10 Thread Stewart Smith
In constructing the list of patches for a project, there are two main queries that are executed: 1) get a count() of how many patches there are 2) Get the page of results being displayed In a test dataset of ~11500 LKML patches and ~4000 others, the existing code would take around 585ms and 858ms