[PATCH] Optimise querying of checks in patch list view

[Daniel Axtens]

> On Thu, 2016-09-15 at 19:21 +1000, Daniel Axtens wrote:
>> > 
>> > Hmm. I wonder if this has an impact on my todo-list issue as well?
>> > 
>> > Perhaps you have an easy way to check that? I don't actually have a
>> > local setup right now :(
>> > 
>> I was going to have a look shortly. I haven't actually played with
>> to-do lists before, but the same tools I used to find this should
>> help identify any obvious problems there too.
>
> Did you ever get a chance to look at this?

Umm, not yet sorry! Sadly patchwork is not my main task at work, so it
gets pushed down the list a bit :(

>
> Regardless of that, in a way, what's the easiest way to have a local
> instance, and feed it with some test data? It seems that patchwork
> requires mysql or postgres, or could it also use sqlite for local
> testing?

This is now a lot easier than it used to be if you're willing to use
Docker on your local machine: that will set up a mysql server
environment and a development environment, without installing anything
on your local machine outside the docker images.

Alternatively, yes, you can use sqlite, but I think the tests don't all
pass... I haven't tried it, but there's something in the docs on it.

Regards,
Daniel

>
> johannes