On Sat, 29 Dec 2012 00:04:12 +0100, Krzysztof <dib...@wp.pl> wrote: > I don't understand :/ So what is solution in my case?
You could try : PRAGMA temp_store=file; immediately followed by: PRAGMA temp_store=memory; Please note: http://sqlite.org/pragma.html#pragma_temp_store "When the temp_store setting is changed, all existing temporary tables, indices, triggers, and views are immediately deleted." Warning: I didn't do any real research on this, and not all your requirements so I'm not sure this is of any help. -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users