--- Martin Jenkins <[EMAIL PROTECTED]> wrote: > For :memory: databases, long periods > were observed where the VM size crept up but I/O write bytes did not, > followed by periods where I/O bytes increased.
If you use "PRAGMA temp_store=MEMORY" with your :memory: database you will have no I/O whatsoever: PRAGMA temp_store=MEMORY; begin; select datetime("now"); create table t(id INTEGER, t TEXT); insert into t values (1,'Hello'); insert into t select * from t; insert into t select * from t; insert into t select * from t; insert into t select * from t; insert into t select * from t; insert into t select * from t; insert into t select * from t; insert into t select * from t; insert into t select * from t; insert into t select * from t; insert into t select * from t; insert into t select * from t; insert into t select * from t; insert into t select * from t; insert into t select * from t; insert into t select * from t; insert into t select * from t; insert into t select * from t; insert into t select * from t; insert into t select * from t; insert into t select * from t; insert into t select * from t; insert into t select * from t; insert into t select * from t; end; select datetime("now"); __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com