[sqlite] Query times vary between 0.2 s and 30 s for very

[Simon Slavin]

On 25 Mar 2015, at 3:28am, James K. Lowden <jklowden at schemamania.org> wrote:

> Is there some lower bound on either the size of the IN list or the
> number of rows in the table being queried?

There's nothing in the language to stop you from executing "... WHERE c IN (12) 
..." on a zero-row table.  It won't be efficient, but it will give the correct 
result.

Simon.