Re: [PATCH 03/11] Add index for patchwork_comment (submission_id, date)

2018-09-09 Thread Stewart Smith
Stephen Finucane writes: > On Fri, 2018-08-10 at 18:00 +1000, Stewart Smith wrote: >> This (at least theoretically) should speed up displaying comments >> on patches/cover letters. It's an index that will return rows >> in-order for the query that we always do ("give me the comments >> on this

Re: [PATCH 03/11] Add index for patchwork_comment (submission_id,date)

2018-08-31 Thread Stephen Finucane
On Fri, 2018-08-10 at 18:00 +1000, Stewart Smith wrote: > This (at least theoretically) should speed up displaying comments > on patches/cover letters. It's an index that will return rows > in-order for the query that we always do ("give me the comments > on this submission in date order"), rather

[PATCH 03/11] Add index for patchwork_comment (submission_id,date)

2018-08-10 Thread Stewart Smith
This (at least theoretically) should speed up displaying comments on patches/cover letters. It's an index that will return rows in-order for the query that we always do ("give me the comments on this submission in date order"), rather than having to have the database server do a sort for us. I