title: Obj-c, What's the quickest way to execute many SQLite insert / update queries, without core data?
body: <p>I'm committed along the route of using SQLite without core data.</p>
  
  <p>I need to speed up a function which performs some database transactions after querying the database. I've created a dictionary for the rows with all the values I'll need.</p>
  
  <p>I need to do this to avoid the database locking.</p>
  
  <p>At the moment I'm calling my add record to database function, which opens and closes the database each time.</p>
  
  <p>Obviously this is where the process is slow.</p>
  
  <p>I was thinking that it's common for apps to be embedded with a database setup script, so it must be possible to run a batch of queries.</p>
  
  <p>So I'm thinking if I can build up a string with all my queries I could just execute that.</p>
  
  <p>But I'm not 100% this is the best approach or how to execute batch queries.</p>
  
  <p>Can anyone advise me how to proceed?</p>