On 01/16/2013 02:21 PM, Ashok Pitambar wrote:
Hi All,I have used sqlite for Database in my client , to speed up the performance I used *"begin"(BEGIN;) *and *"end"(END;)* query transactions to include multiple transactions in single transaction. This helped in performance by reducing the time taken to write all the transactions but when I used this for some of the DB operations sqlite throws error "unable to open database file".If I remove the changes it works fine.What could be the problem here?
It might be failing to create a temporary file to use for a statement journal. http://www.sqlite.org/pragma.html#pragma_temp_store _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
