>What do you mean "how to use sqlite_table"? Do you mean how to design >effective database tables and query them efficiently using SQL?
The meaning of "how to use sqlite_table" is that I guess the sqlite_table may have contained some information which could help to improve speed. I am not meaning to modify the data structure of sqlite_master. I am also not meaning to "Do you mean how to design effective database tables and query them efficiently using SQL". WQG best regards At 2015-12-21 12:44:28, "Keith Medcalf" <kmedcalf at dessus.com> wrote: > >> The reason why I asked the question is that I want to improve the >> spped, although the current SQLite is not too slow. > >> But the speed is not very ideal. So I still try any methods to improve >> the performance of SQLite. I will try the following aspects: >> first method , configure settings; >> second method , the other is how to use sqlite_table, could the >> sqlite_master table help us improve performance ? > >You have not stated what is "too slow" yet, or what it is that you seek to >speed up. > >What do you mean "how to use sqlite_table"? Do you mean how to design >effective database tables and query them efficiently using SQL? > >sqlite_master is an internal data structure which you should not be touching. > > > > > >_______________________________________________ >sqlite-users mailing list >sqlite-users at mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
