Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is it better to store data in plist or Sqlite database? [duplicate]

In my iPhone app, I have large amount of data i.e. around 1000 pages of text.

Where should I do to store them?

Should I use plist or Sqlite Database table?

Which of them would prove to be more efficient?

Please Help and Suggest.

Thanks in Advance.

like image 665
Parth Bhatt Avatar asked Nov 25 '10 11:11

Parth Bhatt


People also ask

Is SQLite a good choice?

SQLite works great as the database engine for most low to medium traffic websites (which is to say, most websites). The amount of web traffic that SQLite can handle depends on how heavily the website uses its database. Generally speaking, any site that gets fewer than 100K hits/day should work fine with SQLite.

How stable is SQLite?

SQLite is a high-reliability storage solution. It does not give problems. It just works.

Is SQLite the most used database?

SQLite is one of the most popular and easy-to-use relational database systems. It possesses many features over other relational databases. Many big MNCs such as Adobe, use SQLite as the application file format for their Photoshop Lightroom product.

When to use SQLite?

SQLite usually will work great as the database engine for low to medium traffic websites (which is to say, 99.9% of all websites). The amount of web traffic that SQLite can handle depends, of course, on how heavily the website uses its database.


3 Answers

For big amount of data, sqlite or coreData are better because all data are not load in memory to access to one.
With pList, entire file is read in memory. After, you can retain only data what you want, but it is not optimized.

like image 143
Benoît Avatar answered Sep 30 '22 18:09

Benoît


Depends on how and for what you want to store the data:

Use SQLite if:

  1. Data needs to be accessed only partially
  2. Repeated updates
  3. Data itself is large in terms of bytes

Use plist otherwise!!

In your case, I would reccomend, using SQLite 3 or coredata.

like image 42
Jaykay Avatar answered Sep 30 '22 16:09

Jaykay


You should use a plist for storing configuration settings.

For what you're doing I'd use sqlite3 or core data storage.

like image 37
xil3 Avatar answered Sep 30 '22 17:09

xil3