> hai, > this is lakshmikanth, i am trying to retrieve 10,000 rows from emp table by > using > ResultSet obj in java,but it displays an errormsg > i.e OutofMemoryError . > ow can solve the problem,plz suggest me to retrive 10,000 rows from database > table. > > thanks, > m.lakshmikanth. >
Hi Kanth: A possible strategy would be to retrieve say first ten records out of the 10,000 rows that you are currently trying to work with. Based on the user selection in the UI, you can navigate to the next requested set of records to fetch. As a practical illustration consider the case of email, you may have large number of mails in your mailbox, however you are shown a limited set of mails and work with even fewer. thanks Saifi.
