Re: [RFC PATCH] 3x improvement in patch listing

2018-08-09 Thread Konstantin Ryabitsev
On Thu, Aug 09, 2018 at 11:55:16AM +1000, Stewart Smith wrote: Out of interest, does the kernel.org instance back onto PostgreSQL or MySQL? We have one of each. The original instance patchwork.kernel.org is on MySQL (well, MariaDB), because that's the database cluster we have in our PDX DC.

Re: [RFC PATCH] 3x improvement in patch listing

2018-08-08 Thread Stewart Smith
Daniel Axtens writes: > Daniel Axtens writes: > >> Konstantin Ryabitsev 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 quer

Re: [RFC PATCH] 3x improvement in patch listing

2018-08-08 Thread Stewart Smith
Konstantin Ryabitsev 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

Re: [RFC PATCH] 3x improvement in patch listing

2018-08-08 Thread Daniel Axtens
Daniel Axtens writes: > Konstantin Ryabitsev 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 eac

Re: [RFC PATCH] 3x improvement in patch listing

2018-08-08 Thread Daniel Axtens
Konstantin Ryabitsev 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: > > Thank

Re: [RFC PATCH] 3x improvement in patch listing

2018-08-08 Thread Konstantin Ryabitsev
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 w

[RFC PATCH] 3x improvement in patch listing

2018-08-08 Thread Stewart Smith
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. If we look at the query getting the list, it gets a lot of unnesseccary fields such as 'headers' and 'content', even though