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
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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
