Most applications won't be heavy users of SQLite, and therefore you very likely won't have to worry too much about performance when dealing with databases. However, you need to know about a few concepts in case you ever need to optimize your SQLite-related code in your Android application:
NOTE: This section is not intended to be a complete guide to SQLite but instead provides you with a few pointers to make sure you use databases efficiently. For a complete guide, refer to
www.sqlite.org and the Android online documentation.
The optimizations covered in this section do not make the code harder to read and maintain, so you should make a habit of applying them.
At the origin, ...