DB-murdering API query (index suggestions needed)
stewart at flamingspork.com
Sat Nov 16 07:04:22 AEDT 2019
> On 15 Nov 2019, at 09:43, Konstantin Ryabitsev <konstantin at linuxfoundation.org> wrote:
> On Sat, Nov 16, 2019 at 12:48:33AM +1100, Daniel Axtens wrote:
>>> The query behind this takes about 1 minute to run on a 20-core HT Xeon
>>> system and requires creating a huge temporary file (there are 18375
>>> patches in that project).
>> Ouch, I'm sorry to hear that.
> Well, it's true that some of kernel.org's projects are large beyond what
> would be considered "sane". :)
My thought is that we should make it so that Patchwork is able to cope.
It’s not *that* much data or that complex queries (he says with his database hat on) :)
More information about the Patchwork