Re: DB-murdering API query (index suggestions needed)

2019-11-17 Thread Stewart Smith
> On 15 Nov 2019, at 09:43, Konstantin Ryabitsev > wrote: > > On Sat, Nov 16, 2019 at 12:48:33AM +1100, Daniel Axtens wrote: >>> GET >>> /api/1.1/patches/?project=62=2019-11-01T00:00:00_page=100=6150 >>> The query behind this takes about 1 minute to run on a 20-core HT Xeon >>> system and

Re: DB-murdering API query (index suggestions needed)

2019-11-17 Thread Stewart Smith
> On 15 Nov 2019, at 05:48, Daniel Axtens wrote: > >  >> >> Today, the DB behind patchwork.kernel.org was in a semi-permanent state >> of suffering due to someone trying to suck down all patches in the >> linux-arm-kernel project. This is what the API request looked like: >> >> GET >>