title: Does a large number of arguments in the WHERE IN() clause affect performance in sqlite?
body: <pre><code>SELECT * FROM atable WHERE some_id IN(3,5,2)
  </code></pre>
  
  <p>This is ok. But what if I have to pass 1000 IDs? Will it slow down the query? </p>
  
  <p><code>some_id</code> is always indexed.</p>
  
  <p>I know I probably shouldn't pass that number of arguments, but I need to get a large number of records from a table, then get related records from 2 other tables. If I use JOINs the returned array is huge. So I figured I should just do the main query, then two other queries for the related tables using the IN clause where I pass the IDs from the main query</p>