I have a flatfile which may contain more than 20000 lines where each line represents a record that needs to be updated in DataBase. I parse each line, perform mapping, validation etc and then call “execSQL” service to update the database. So I am calling execSQL 20000 times in a loop. well, as expected, performance is very poor in this case.
Is there any way I can send a batch (say 200) of update statements to DataBase at a time? does execSQL service allow us to do this ?
please give your valuable comments. also suggest the best way to increase the performance in this case.
Thanks in advance