I have requirement to read the excel data and based on some conditions ih ave either insert/ update the data in to Oracle tables. to check the condition I have to loop through the 4 columns for 4 conditions which may consist of huge number
of records, where performance issue arise here. please put me in the right way or suggest me a best approach to break through the performance issue as well.
ofcourse i am writing in a service.
View Complete Post