loading big CSV file to SQLITE database
I have a very big CSV file (25 MB) with 90K lines and i am trying to make an Android app that will load this What would be the most efficient way to load it to SQL db? Is that even possible? Any idea how long loading it will take?
If you're looking for a way to ship data with you app you can include a prepopulated db in the apk, which is a much better experience for the users: How to ship an Android application with a database?