SQLite Forum

Performance issues with query parameters vs. static strings
Hi thanks for the verbose reply,

yeah I see where we are coming here. Now the only question is, how this could be done through the .NET wrapper? I think those guys would have to find a way how to optimize this.

UPDATE: We just lowered the number of IN parameters and found a sweet spot at 100. It seems we can fight the problem with that a little bit, until we have a proper solution :)

Thanks BR