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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
