I have 4 static CSV files containing data. Each file is 1.1 to 1.5 M each. I want to read data from these files and let the user choose which file and what information he needs from this file. With access to performance on Android devices in mind, I'm trying to get a better approach to reading this data. I know that using a CSV reader is faster, but I'm confused if using SQLite db instead. Also I'm not sure if this is the right approach to store 4 SQLite db on the phone and read from it. And ideas about the approach I should take in order to get data from these 4 CSV files faster, using less memory and faster processing speed. Any help is appreciated.
source share