Author: kotkov Date: Tue Aug 20 09:23:55 2019 New Revision: 1865523 URL: http://svn.apache.org/viewvc?rev=1865523&view=rev Log: When compiling SQLite, enable the SQLITE_OMIT_WAL compile-time option.
We don't use WAL (write-ahead logging) feature of SQLite, but just keeping it enabled has a visible I/O performance penalty, because SQLite has to check if the write-ahead log file is present on disk. In a couple of my experiments, disabling this feature resulted in a ~10% faster `svn st` on a large working copy. * subversion/libsvn_subr/sqlite3wrapper.c (): Define SQLITE_OMIT_WAL. Modified: subversion/trunk/subversion/libsvn_subr/sqlite3wrapper.c Modified: subversion/trunk/subversion/libsvn_subr/sqlite3wrapper.c URL: http://svn.apache.org/viewvc/subversion/trunk/subversion/libsvn_subr/sqlite3wrapper.c?rev=1865523&r1=1865522&r2=1865523&view=diff ============================================================================== --- subversion/trunk/subversion/libsvn_subr/sqlite3wrapper.c (original) +++ subversion/trunk/subversion/libsvn_subr/sqlite3wrapper.c Tue Aug 20 09:23:55 2019 @@ -26,6 +26,7 @@ #ifdef SVN_SQLITE_INLINE # define SQLITE_OMIT_DEPRECATED 1 # define SQLITE_DEFAULT_MEMSTATUS 0 +# define SQLITE_OMIT_WAL 1 # define SQLITE_API static # if __GNUC__ > 4 || (__GNUC__ == 4 && __GNUC_MINOR__ >= 2) # pragma GCC diagnostic ignored "-Wunreachable-code"