HI,
In my project i need to write a batch(
java) which will read a CSV file from FTP location consisting more than 5 lakhs records and update a table in my database (Oracle 10g). My concerns here are :
- processing Time
- garbage collection(Stack overflow problem etc.)
- DB handling
Can anybody tell me how can i achieve this, so that it takes very less time without without collecting chunks of data.
Thanks & Regards,
Namrta.