Re: [sqlite] Facing SQLite ERROR : unable to open database file error

2013-01-16 Thread Dan Kennedy
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

Re: [sqlite] Facing SQLite ERROR : unable to open database file error

2013-01-16 Thread Ashok Pitambar
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

Re: [sqlite] Facing SQLite ERROR : unable to open database file error

2013-01-16 Thread Dan Kennedy
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

Re: [sqlite] Facing SQLite ERROR : unable to open database file error

2013-01-16 Thread Ashok Pitambar
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

Re: [sqlite] Facing SQLite ERROR : unable to open database file error

2013-01-16 Thread Michael Black
Is there some reason there's the rather poor unable to open message without the actual error message? Strerror coming to mind if it hasn't disappeared under foot at those places? I see these questions on the list fairly often and they would all be answered with an intelligent error

[sqlite] Facing SQLite ERROR : unable to open database file error

2013-01-15 Thread Ashok Pitambar
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