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

2019-11-15 Thread Konstantin Ryabitsev
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 (th

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

2019-11-15 Thread Daniel Axtens
> 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 > /api/1.1/patches/?project=62&before=2019-11-01T00:00:00&per_page=100&page

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

2019-11-15 Thread Andrew Donnellan
On 15/11/19 11:44 am, Konstantin Ryabitsev wrote: Hi, all: 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 /api/1.1/patches/?projec