The subject pretty much says it all, I use sqlite3 as a way to save temporary results from a calculation.
In this context I do not care about safety of the data. If the program fails or there is a blackout I will just delete the sqlite3 file, eventually fix the bug, and restart. At the moment I use this pragmas: PRAGMA synchronous = OFF; PRAGMA journal_mode = MEMORY; PRAGMA cache_size = -10240; Is there anything other I can do to speed-up sqlite3 at expenses of safety? Thanks, Paolo _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
