On 23 Dec 2015, at 4:46am, ??? <2004wqg2008 at 163.com> wrote: > sqlite3_soft_heap_limit64() , cache_szie and so on also which could not help > improve the speed
These commands reduce the amount of memory your application uses. They will not help increase the speed unless you are repeatedly searching for the same rows. Compilation options are the wrong place to look if you are trying to increase your speed. You are at the wrong end of the software. You should be looking at the SQL commands you execute and the schema of your tables. You seem to be searching using the primary key of your table which is an integer, so there's no simple way to increase speed there. If you really need every column in the table in your answer there's no way to increase speed there either. Simon.
