Got it , Thanks Dan. On Wed, Jan 16, 2013 at 4:29 PM, Dan Kennedy <danielk1...@gmail.com> wrote:
> On 01/16/2013 05:42 PM, Ashok Pitambar wrote: > >> Thanks Dan, >> >> I will try by setting this pragma but still I don't understand why it is >> failing for few query operations. >> > > The temporary files might be statement journals. Which are only required > by some statements and only if they occur within a BEGIN/COMMIT block. > > > http://www.sqlite.org/**tempfiles.html#stmtjrnl<http://www.sqlite.org/tempfiles.html#stmtjrnl> > > > >> 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> >>> <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> >>> <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<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<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
