First, the concept of CoreData and SQLite is different, the core is the object cycle management, and SQLite is the DBMS.
The following discussion is based on the use of core data to persist and use SQLite as a backend storage condition.
- Ease of use. In fact, a mature project must be a data persistence package, so the bottom of the use of core data or sqlite, should not be the business logic developers concerned. Therefore, even people who are accustomed to writing SQL queries should avoid writing SQL statements directly in the business logic.
- Storage performance, in the write performance, because all are used in the SQLite format as a disk storage format, so its performance is the same, if you think with core data write slow, it is likely that you use SQLite when you write the content of each piece of data without core data when more, Or when you write in bulk, the save is called every time you write a message.
- Query performance, core data is compatible with a variety of backend formats, so when querying, its available statements are less than the direct use of sqlite, so some fetch is not actually performed in SQLite. However, this will not necessarily reduce the efficiency of the query. Because the iphone flash memory speed is still very fast. My experience is that most of the time, when the memory is not very tense, it is often faster to fetch all the data from an entity and then make the filter in memory more quickly than using predicate in fetch. If you think the query is slow, it is likely that the query method has a problem, you can open the debug mode of core data to see how many SQL statements executed, I believe most of them can be overridden by the core data to avoid the call way.
- One of the big pain points of core data is that when people work together, the model of managing coredata needs to be careful, especially when merging, his data model is in XML format, and manual resolve is more annoying.
- Core data has other advantages that SQL does not have, such as support for undo, and multiple context implementations sketchbook similar functionality. The row cash optimized for ManagedObject.
- In addition, core data is multi-threaded, but requires thread confinement implementation, using multithreading can be maximized to prevent blocking the main thread.
The difference between CoreData and SQLite
