>The key is turn off journaling and use transactions effectively (ie. try to batch as much as you can into a single transaction for write operations). > >There are 'Pragma' commands you can use as a Sql command to set these options. > >Here's a good SO entry that talks about some of the things you can do: >http://stackoverflow.com/questions/1711631/improve-insert-per-second-performance-of-sqlite