SQLite Forum

Performance issues with query parameters vs. static strings
Login
Sending parameters into SQLite engine is not essential to do the “in” test.   You may be able to avoid all the parameter passing overhead by simply writing a function to do the “in” check in your .NET  code, register the function with SQLite and call it from the SQL query:

Let’s say you write a function called “my_in(String) in .NET
and register it with SQLite as described here: 
https://stackoverflow.com/a/172845

Then just use it:

Select * from table where my_in(agg)


Ps: Mailing list was so much better;  Hate composing replies on the forum on iPhone - cannot even see the whole thread while composing.