Sqlite or Array List

Question

I am unsure of what would be the best method to save data in my app. Its its Map app and for each location I would want to save certain characteristics for example like shown here:

I wouldn't need to be able to edit the data in the app It could just be readable.
I would want the be able to search if each Id had certain attributes then only display those on a map.
I would also want to be able to access the data for display on a map
There would be up to around 400 Id's.
The Data would ideally be stored in different types (string, integer, decimal).

Would it be best to save this data in a database like SQLite or a massive array list, or is there a better way?

Thanks in advance.

better use Sqlite since u have N number of rows, it is easy to store as well as to access — Nandakishore Shetty
– Nandakishore Shetty, Commented Oct 16, 2015 at 11:18

IntelliJ Amiya · Accepted Answer · 2015-10-16 11:28:01Z

2

SQLite is a opensource SQL database that stores data to a text file on a device. Android comes in with built in SQLite database implementation.

If you have data related with each other, file will not allow you to relate them. At that time SQLite will help you.
If you wan to query your data, store the data in structured manner you will prefer SQLite Than ArrayList
SQLite has higher performance

Please read this article Why should we use SQLite in Android development?

My Advise

Use Sqlite .

edited Oct 16, 2015 at 11:28

answered Oct 16, 2015 at 11:21

IntelliJ Amiya

75.8k15 gold badges169 silver badges199 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sqlite or Array List

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related