Currently we access a single SQLite database in a single thread but I am working on changing this as performance has become a real problem. We will be using WAL mode and there will be one thread for writes and multiple threads for reads. For many cases, speed will be of a priority and it will not matter if the data returned from a read is slightly out of date so I can considering using #pragma uncommitted in some of the reader threads. Will #pragma uncommitted work in WAL mode and will it have the effect I'm looking for (where the read will be faster because it can ignore the recently written information in the WAL File) and simply use the database file only?
Thanks _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users