> 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.