Read large file into sqlite table in objective-C on iPhone
- by James Testa
I have a 2 MB file, not too large, that I'd like to put into an sqlite database so that I can search it. There are about 30K entries that are in CSV format, with six fields per line. My understanding is that sqlite on the iPhone can handle a database of this size.
I have taken a few approaches but they have all been slow 30 s. I've tried:
1) …