While tracking all the I/O that SQLite does I noticed that the same 16 bytes are read over and over again. After some investigation I found out that it is reading the File change counter to see if another process has changed the database.
As in this program there is only one read-only process that has a lock on the database there is no way that the database could have been changed. So it would be nice, to minimize the amount of reads and gain performance, to not read this File change counter all the time. I tried to accomplish this by opening the database using an exclusive lock but that had no effect. Is there any way to accomplish this? _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
