How about the following settings:
SQLITE_DEFAULT_FILE_FORMAT=4; SQLITE_MAX_ATTACHED=30; SQLITE_ENABLE_COLUMN_METADATA; SQLITE_ENABLE_FTS4; SQLITE_ENABLE_FTS4_PARENTHESIS; SQLITE_ENABLE_RTREE; SQLITE_THREADSAFE=2; NDS_ENABLE_ZLIB; NDS_ENABLE_AES; NDS_ENABLE_COLLATIONS At 2015-12-21 11:42:14, "Simon Slavin" <slavins at bigfraud.org> wrote: > >On 21 Dec 2015, at 3:17am, ??? <2004wqg2008 at 163.com> wrote: > >> When we compile the sqlite source code, there are so many >> configuration, such as >> SQLITE_DEFAULT_FILE_FORMAT=4; >> SQLITE_MAX_ATTACHED=30; >> SQLITE_ENABLE_COLUMN_METADATA; >> SQLITE_ENABLE_FTS4; >> My question is that could different configuration influence the >> perfomance of the sqlite? and how it influence the performance? > >None of the above settings will influence speed. > >If you want to know about things that can influence speed please read > ><https://www.sqlite.org/pragma.html> > >Simon. >_______________________________________________ >sqlite-users mailing list >sqlite-users at mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users