*** 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?