Stephen, Simon,
Thanks for your replies.
On 03/07/2013 05:43 PM, Stephen Chrzanowski wrote:
Check file attributes, then NTFS permissions.
That was it:
- I opened the folder containing the sqlite database in Explorer,
- right clicked on the database file,
- chose Properties -> Security -> Users
- pressed Edit
- ticked "Modify" and "Write" permissions.
- pressed Apply.
Now it's the same fast under IIS (aroud 0.01 seconds).
Excellent! Thank you very much.
I have a new related question now.
How do I ask sqlite to create the file with these permissions
when I send the "CREATE TABLE" statements?
Thanks.
I've found the same thing
(Delay of about 2 seconds on initial access to the database) when my
Windows application encounters the database in a read-only state.
On Thu, Mar 7, 2013 at 8:28 AM, Alexander Barkov <b...@mnogosearch.org>wrote:
Dear SQLite experts,
I'm developing a Web CGI application.
It opens an sqlite3 database, executes few SQL queries
and displays the results in HTML format.
The database is quite small (less that 3mb).
The application fetches a very small part of the data
using indexes.
My problem is that sqlite3_open() for some reasons
takes about 1.5 seconds on Windows under IIS 8 web server
when I open the database in readwrite mode.
In all other conditions it takes less than 0.01 seconds:
1. It works fine on Linux, both under Apache
and when executed from command line.
2. It works fine on Windows under IIS
if I use sqlite3_open_v2(SQLITE_OPEN_**READONLY)
3. It works fine on Windows when executed from command line
even if I open the database in readwrite mode.
4. But it takes 1.5 seconds under IIS in readwrite mode.
I thought that it's probably somehow related to the privileges that the
IIS service is running with, and possibly sqlite tries to open some log
files (or similar) in the locations it does not have access to.
I tried to put the database file into "C:\Windows\Temp",
and tried to set "SQLITE_EXTERN char *sqlite3_temp_directory"
to "C:\Windows\Temp", but nothing helped.
Can you please suggest how to improve performance of sqlite3_open?
Thanks.
______________________________**_________________
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
