DB-murdering API query (index suggestions needed)

[Stewart Smith]

> 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:
>>> GET
>>> /api/1.1/patches/?project=62&before=2019-11-01T00:00:00&per_page=100&page=6150
>>> 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) :)