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.
