SQLite is an Open Source Database which is embedded into Android. SQLite is available on every Android device.
SQLite require very less memory at runtime (approx. 250 KByte)
Enternally SQLite database creates filesystem so this may be slow, Therefore it is recommended to perform database operations inside the AsyncTask class.
Android Application Development Video Tutorial,Download and Install the Java JDK,Installing Eclipse and Setting up the ADT,Installing Android SDK and Set up Emulator,Setting up an Android Project
** A Service runs with the main application thread , so some time user interaction will lock the current application . Use Service inside a separate thread, you will reduce the risk of Application Not Responding (ANR) errors . So application's main thread can remain dedicated to user interaction with your activities.
** If you are starting service inside any activity then it will block activity so when created service done then only your activity will unlock. in this mean time if user will interacting to activity then Application Not Responding (ANR) errors will come.
** If you want user interaction on when activity is visible and also some server or time taking tasks(performs intensive or blocking operations) then you might create a thread in onCreate(), start running it in onStart(), then stop it in onStop(). Also consider using AsyncTask or HandlerThread, instead of the traditional Thread class
An Activity is an application component that provides a screen with which users can interact in order to do something, such as dial the phone, take a photo, send an email, or view a map. Each activity is given a window in which to draw its user interface.