开发者

Android SQLite Index Optimization

开发者 https://www.devze.com 2023-01-12 16:14 出处:网络
I am optimizing our database for Android SQLite. The data is simple, 3 ints (Country, State, City) The data is stored in order by Country, State and City.

I am optimizing our database for Android SQLite.

The data is simple, 3 ints (Country, State, City) The data is stored in order by Country, State and City.

If I create an index on the three fields in ASC, would that be the most effi开发者_JAVA技巧cient given that we "READ-ONLY" the data 100% of the time by the 3 fields?


Database optimisation depends highly on how you query it (i.e. what you query it for). In other words, if you post some queries, I might be able to better answer your question.

0

精彩评论

暂无评论...
验证码 换一张
取 消