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 paused for the 2 second period. I've NEVER looked at, which inherently means I've never traced into, SQLites code to validate what I've found. But with my Delphi SQLite wrapper, and the SQLite CLI, I get the same delayed results.
On Thu, Mar 14, 2013 at 12:34 AM, Mohit Sindhwani <m...@onghu.com> 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 they seem long to us. > > We are using: > sqlite3_open_v2(sFilePath, &db, SQLITE_OPEN_READONLY, NULL); > > What are the kinds of things that would slow down opening the database? > > Database size? > > Database schema? > > CEROD? > > If someone in the know can throw some light on this, we can try to see how > to mitigate the timing. > > I know there was a recent thread on sqlite3_open taking 1.5s under IIS and > that was a permissions issue. That is not the case for us (since we are > using a read-only CEROD database) > > Thanks & Best Regards, > Mohit. > > > ______________________________**_________________ > 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
