about sqlite3_exec(m_pDB, "PRAGMA synchronous = OFF;", 0,0,0); The testing shows that It can not improve the speed of retrieving records from data base. Thank Simon all the same.
At 2015-12-21 18:20:49, "Simon Slavin" <slavins at bigfraud.org> wrote: > >On 21 Dec 2015, at 10:07am, ??? <2004wqg2008 at 163.com> wrote: > >> CREATE TABLE poiTable (poiId INTEGER NOT NULL, versionId INTEGER NOT >> NULL, regionId INTEGER , postalCode TEXT , phone TEXT , attrBitMask INTEGER >> , attributeBlob BLOB , primary key (poiId)); >> So the poiId is equal to the rowid. >> >> such as : select * from poiTable where poiId = ... ; >> And execute the sql by sqlite3_prepare_v2?sqlite3_step? >> how could I improve the performance? > >I think you are correct. You already have an ideal index for the poiId >column. So I'm afraid you will have to look at other things. > >One thing is that if you do not actually want all the columns you should >select just the columns you want instead of doing "SELECT *". > >Simon. >_______________________________________________ >sqlite-users mailing list >sqlite-users at mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users