Small. Fast. Reliable.
Choose any three.
*** 247,249 ****
--- 247,251 ----
  This feature can often be used to great advantage when having multithreaded access to the database.
  By creating a temporary table containing the results of a large query for processing, rather than
  processing it directly out of the main database, you greatly reduce lock contentions.
+ 
+ (comment) discussion about this at http://sqlite.phxsoftware.com/forums/2284/ShowThread.aspx#2284