Geek Answers Handbook

What happens faster when reading large amounts of data: XML or SQLite

I will be developing a dictionary application for Android and iPhone. The data will be embedded in the application and will consist of approximately 100,000 words indicating the gender and plural. Is it better to use a SQLite database or can I just stick with XML? Somehow, SQLite sounds more efficient, but I thought I might just ask.

Thanks!

+4
source share
3 answers

This is a little comparison of apples and oranges. SQLite is much more than just a file format. The answer depends on whether you just want to load everything into memory at startup (XML, or better yet, CSV is likely to be enough), or you want to be able to query for data, in which case SQLite is a much better choice.

+5
source

You want to do a search, so SQLite will definitely be faster. You will need some function to install your data from a distributed executable into SQLite, of course ...

+2
source

XML is better for storing data trees (hierarchical data structures) and for exchanging data.

SQL is better for data tables.

In your situation (from what you shared with us), SQL (and therefore SQLite) sounds much more efficient.

+1
source

More articles:


All Articles