maximum number of data resultset can handle at a time

[gagan narula]

hi
can any one please tell me
the maximum number of data result set can carry at a time and how he handles with that data say number of data is around 1 million.

[vu lee]

It depends on (1) the underline JDBC impl provider and (2) how much memory your app server has.
You can break it down to several chunks and process one chunk ( or several chunks) at a time.