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?

Thank you

Answers


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?


Need Your Help

Necessary nodes in Web.config

.net asp.net-mvc

What are the necessary nodes in my Web.config file? I'm using VS 2012 though my project is ASP.NET MVC 3 type.

function pointer returning another function pointer in C++ with locality

c++ c pointers function-pointers localityofreference

Considering the fact that a pointer to a function returning another pointer to another function is the mechanism used in C to introduce some runtime polymorphism/callbacks, What is the equivalent w...