title: SQLite record update speed improvements
body: <p>I currently have trouble updating SQLite database records at scale within a healthy amount of time.</p>
  
  <p>I have a small database of about 70,000 records and I have some office personal using Navicat to filter the records and make some bulk edits to commit. When trying to perform an UPDATE on a large amount of records in one field everything comes to a crawl, when I look at the raw SQL query I can see that the program is using an UPDATE ..SET.. WHERE to perform the operations. </p>
  
  <p>My question is what can I do to help this query run faster? I have a SQLite auto index on the column used for matching the record to update, but I have read and searched all over and have yet to see any kind of resolve other then what I already have in place. Updating one field in 20,000 records is literally taking close to 3 hours...regardless of using Navicat or not. The whole database is only 30mb so I have to be doing something wrong.</p>
  
  <p>All other database operations run nice and speedy, not sure whats wrong and looking for some guidance from a SQLite vet. </p>