Thanks Dan, I will try by setting this pragma but still I don't understand why it is failing for few query operations.
Regards, Ashok On Wed, Jan 16, 2013 at 1:46 PM, Dan Kennedy <danielk1...@gmail.com> wrote: > 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<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<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
