Hi! I will be making a mobile application in Android. My application is like Google Map's Get Direction feature, but a lot more complex, so I need to store data about points in the map. So I'm worried that SQLite may not be able to handle these large amount of data(or considering the limited storage of the phone). I have no background in SQLite so please bear with me. Thanks in advance! :D
+5
A:
SQLite can handle large amount of data, the problem here is the device's limits. If you are going to store 3MB or more you should consider saving that data in an external server and access it via the Internet. In fact, when you are building an application that use large amount of data, usually the application don't use all data all the time, so you can save in cache (in a local database) the data that the app is currently using or is about to use.
Cristian
2010-06-26 14:42:16
Thanks for that. Hmmm now considering that, can I use MySQL as my external database, then ,of course, SQLite for my local database. Will that have any effect?
2010-06-26 15:31:46
The only effect it will have is that you are going to have to establish an Internet connection.
Cristian
2010-06-27 22:37:25
+1
A:
I think the best way to find out is to write a simple app that simulates the types of transactions you'll be doing and see how it does.
You might also want to compare how SQLite does to an object database like db4o, which is very performant and used very often as an embedded database (and can easily handle gigs of data).
mgroves
2010-06-26 14:43:08