Android question and Answer question

1. Does SQLite support the business? How does adding a delete improve performance?

SQLite as a lightweight database, support transactions, improve performance can be considered through the original optimized SQL query statement processing, if it is a bulk operation, can be placed in a transaction to improve performance.

2. Why use ContentProvider? What is the difference between it and SQL implementation?

the reason for using it is to enable sharing of data between different applications.

The same point as SQL : its bottom layer is implemented with the SQLite database, so its various operations on the data are implemented in SQL, but the upper layer is provided with a URI.

Unlike SQL : the details of the data store can be masked, completely transparent to the user, and the user only needs to be concerned with the URI of the operational data, so from a security standpoint, the use of ContentProvider is superior.

3. Please explain the relationship between message, Handler, message Queue, Looper in a single-threaded model.

Simply put, handler gets the Looper object in the current thread, Looper is used to remove the message from the MessageQueue that holds the message, and then handler to distribute and process the message.

Android question and Answer question