title: How to query an SQLite db in batches
body: <p>I am using C# with .NET 4.5. I am making a scraper which collects specific data. Each time a value is scraped, I need to make sure it hasn't already been added to the SQLite db.</p>
  
  <p>To do this, I am making a call each time a value is scraped to query against the db to check if it contains the value, and if not, I make another call to insert the value into the db.</p>
  
  <p>Since I am scraping multiple values per second, this gets to be very IO-intensive, with constant calls to the db. </p>
  
  <p>My question is, is there any better way to do this? Perhaps I could queue the values scraped and then run a batch query at once? Is that possible?</p>