Re: [sqlite] IN expression performance

On Thu, Dec 18, 2008 at 7:44 PM, Griggs, Donald wrote: > Regarding: > Is there a way to use a prepared statement and bind a (variable) > array of integers? > >Like in: >SELECT FROM table WHERE someinteger IN ( 2,18,19,340,1,72, 15 > ... ) > >

Re: [sqlite] IN expression performance

"Sander Jansen" wrote in message news:2d51e2b10812180940s7df743e7lf8dcd2d82c5df...@mail.gmail.com > Is there a way to use a prepared statement and bind a (variable) array > of integers? > > Like in: > SELECT FROM table WHERE someinteger IN ( 2,18,19,340,1,72, 15 > ... )

Re: [sqlite] IN expression performance

Regarding: Is there a way to use a prepared statement and bind a (variable) array of integers? Like in: SELECT FROM table WHERE someinteger IN ( 2,18,19,340,1,72, 15 ... ) Becomes: SELECT FROM table WHERE someinteger IN ( ? ) I don't know that you can bind these,

Re: [sqlite] IN expression performance

One more question though, Is there a way to use a prepared statement and bind a (variable) array of integers? Like in: SELECT FROM table WHERE someinteger IN ( 2,18,19,340,1,72, 15 ... ) Becomes: SELECT FROM table WHERE someinteger IN ( ? ) Thanks, Sander On Mon, Dec 15, 2008 at

Re: [sqlite] IN expression performance

thanks! On Mon, Dec 15, 2008 at 4:16 PM, Igor Tandetnik wrote: > Sander Jansen wrote: >> Suppose I have query that does: >> >> SELECT FROM table WHERE someinteger IN ( 2,18,19,340,1,72, 15 >> ); >> >> The list of numbers comes from a user

Re: [sqlite] IN expression performance

Sander Jansen wrote: > Suppose I have query that does: > > SELECT FROM table WHERE someinteger IN ( 2,18,19,340,1,72, 15 > ); > > The list of numbers comes from a user selection, so it doesn't come > from some other table. Would it make a big difference in