Reading text file from app bundle

Question

I am about to read a text file from the app bundle and I have read some of the posts about reading text files such as this: Objective-C: Reading a file line by line

I am going to read about 2000 lines of sql queries when the application launch if there is a new data migration. This will probably one happen once each 2nd month or so. Could I use this selector and just split the lines, put them in an array and loop through each index to execute the sqlite3 function, or would this take to much time?

+ (id)stringWithContentsOfFile:(NSString *)path 
      encoding:(NSStringEncoding)enc 
      error:(NSError **)error

score 2 · Answer 1 · answered Jun 17 '11 at 21:02

2

Why don't you try it out?

Seriously though, that is probably fine. 2000 lines of text is what, 200k of data? That isn't all that much.

answered Jun 17 '11 at 21:02

Simon Goldeen

9,080
3
36
45

score 1 · Accepted Answer · answered Jun 18 '11 at 03:03

1

If possible, I would batch the operation into a transaction to potentially alleviate overhead with running multiple queries, maybe getting some rollback ability in the case of failure. I believe that sqlite has transaction capability.

answered Jun 18 '11 at 03:03

pzearfoss

3,593
1
16
12

Reading text file from app bundle

2 Answers2