Re: [sqlite] Slow sqlite3_open() - possible culprits?

2013-03-24 Thread Mohit Sindhwani
Hi! On 15/3/2013 11:40 PM, Mohit Sindhwani wrote: Hi Richard, On 14/3/2013 8:17 PM, Richard Hipp wrote: On Thu, Mar 14, 2013 at 12:34 AM, Mohit Sindhwani wrote: Hi, we are using SQLite3 + CEROD for a number of databases in an embedded systems application running on Windows CE. We're findi

Re: [sqlite] Slow sqlite3_open() - possible culprits?

2013-03-15 Thread Mohit Sindhwani
Hi Richard, On 14/3/2013 8:17 PM, Richard Hipp wrote: On Thu, Mar 14, 2013 at 12:34 AM, Mohit Sindhwani wrote: Hi, we are using SQLite3 + CEROD for a number of databases in an embedded systems application running on Windows CE. We're finding unexpectedly long time to open the database (0.5s

Re: [sqlite] Slow sqlite3_open() - possible culprits?

2013-03-14 Thread Richard Hipp
On Thu, Mar 14, 2013 at 12:34 AM, Mohit Sindhwani wrote: > Hi, we are using SQLite3 + CEROD for a number of databases in an embedded > systems application running on Windows CE. We're finding unexpectedly long > time to open the database (0.5s ~ 2.8sec). Maybe, these times are > reasonable, but

Re: [sqlite] Slow sqlite3_open() - possible culprits?

2013-03-13 Thread Mohit Sindhwani
Hi Stephen, Thanks for the reply! On 14/3/2013 2:20 PM, Stephen Chrzanowski wrote: If you're attempting to open a read only SQLite database, it seems as though it will take that time to validate write permissions. By "read only", I meant that the database is for reading only. It doesn't hav

Re: [sqlite] Slow sqlite3_open() - possible culprits?

2013-03-13 Thread Stephen Chrzanowski
If you're attempting to open a read only SQLite database, it seems as though it will take that time to validate write permissions. I don't know what CEROD is. In that thread, to which I was a part of, you'll notice that when I changed just the basic file attribute to read only, even the CLI pause

[sqlite] Slow sqlite3_open() - possible culprits?

2013-03-13 Thread Mohit Sindhwani
Hi, we are using SQLite3 + CEROD for a number of databases in an embedded systems application running on Windows CE. We're finding unexpectedly long time to open the database (0.5s ~ 2.8sec). Maybe, these times are reasonable, but they seem long to us. We are using: sqlite3_open_v2(sFilePath