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

2020-03-16 Thread Daniel Axtens
Daniel Axtens writes: > Daniel Axtens writes: > >>> 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 >>>

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

2020-03-16 Thread Daniel Axtens
Daniel Axtens writes: >> 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 >>

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 >>

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=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 requires creating a huge temporary file (there are 18375

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=2019-11-01T00:00:00_page=100=6150 > > >

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

DB-murdering API query (index suggestions needed)

2019-11-14 Thread Konstantin Ryabitsev
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/?project=62=2019-11-01T00:00:00_page=100=6150 The