I am trying to process bulk amount of data....
I am using IBM DB2.
I am reading a list of Item from an Excel using POI interface and for each Item there is a particular set of queries that has to be fired.
The problem is that the if I am running the same set of query for each item then result processing is taking to much of time
(i.e. if the items increases to 50 or above) and ultimately causing the browser to display Request time out error.
Is there to any other way to implement the same with procedure or something ?
Like I have a List
Such as
1001
1002
1003
and so on
now after reading 1001 we fire a set of queries,
and then for 1002 the same set of queries,
and then for 1003..
and so on...