Small. Fast. Reliable.
Choose any three.
*** 45,47 ****
--- 45,51 ----
  I had expected writing to a temporary table to be the same speed
  regardless of whether or not it is within a transaction.  The 
  4x slowdown is puzzling.  I will be looking into this....
+ 
+ ----
+ _E. Russel Harvey on 2004-09-25:_
+ Does a transaction caused file locking prevent not only writing but also reading from other access, which may be from a thread of the same process that SQLLite is running?