SQLite Forum

Performance issues with query parameters vs. static strings
You should probably read [](https://www.sqlite.org/np1queryprob.html) though.

WHERE-IN is essential in client-server RDBMSs, to send all IDs across the  
wire in one network-trip, and get all results (or chunks of them via  
Oracle's row prefetching setting) in as few network-trips as possible as well.

But because SQLite is embedded, individual queries are just as fast. So instead  
of 1x `WHERE col in (:1, ..., :N)` using Nx `WHERE col = :1` (which is a  
single prepared query) is simpler and probably just fast or faster.