SQLite or Core Data for a large database with only queries

Question

Basically, I am writing an iOS application that uses a huge database that will not be edited at all. Between the two, I am looking for faster query speeds. I have never used SQLite or Core Data in my developing life, so before I start writing anything, I want to find out which one (or any alternatives) will be better for my task.

Any performance data or suggestions are welcome.

Edit: Neither SQLite nor Core Data were able to perform the required performance (although SQLite worked better). I decided to go with SQLite (with FMDB) and use multithreading to get rid of the stuttering that occurs with multiple queries.

Answer 1

Depending on how you want to manage your data, if you want to have a relational database, use sqlite and if you want to save model objects (in the sense of the design model of the model-view-controller) to a file and get them back, use Core Data .

According to my words, both of them are the same for a large database, in sqlite you can use transactions to get huge data faster.

This link may help you better.

Hope this helps you.

Answer 2

For me, I will always use basic data whenever possible. Because it is easy to use and manage. For more information you can check these links.

• Master Data and SQLite 3
• Use CoreData or SQLite on iPhone

Here are the good Ray Wenderlich tutorials on Core Data p>

• Basic Data in iOS 5 Tutorial: Getting Started
• Basic Data Tutorial: How to Preload / Import Existing Data

Answer 3

If your issue is performance related, Core Data is good and can efficiently optimize memory. Although, please take a look at these pages that will help you Efficient Storage and Regarding CoreData vs SqlLite . Hope this helps.