how to show data in textview from sqlite database in android?

How can I improve Android app data caching with SQLite and the SD card?

• What are the best ways to improve Android app data caching with SQLite, also leveraging the SD card? Here is one perspective. http://shopwith.it/2011/12/16/how-to-improve-android-app-performance-by-caching-data-in-sqlite-and-images-to-the-sd-card-android-developer-tips/ How have you done this?

• Answer:

  First, caching application data on the SD card is almost never a good idea because The user can subsequently delete the file in which your data is cached. Saving and retrieving application data from a file can be a huge hassle. File I/O is very slow. On the other hand, caching application data in a SQLite database can be useful for situations in which Application data (such as state) needs to persist even after he application is closed. Application data changes rarely (i.e. recipes pulled from a server once a day) There is enough application data to warrant the indexing/lookup benefits of a SQLite database. Note: Indexing and lookup will create overhead so plan accordingly. Application defaults to database data as a backup when the phone goes offline. Allows your application to run independent of Internet connection. These are just some of the possible reasons to use SQLite. The only times I have ever used SQLite are when I needed a persistent copy of my application data. You should be aware that designing a SQLite database with good performance will take extra time. If you are planning to perform many expensive operations on your application data, it is probably best to just keep your data in memory to reduce data access overhead.