MySQL Forums
Forum List  »  Newbie

Iterating through SQL table
Posted by: K R
Date: April 18, 2009 01:10PM


I have a presumably primitive Problem.
I have a really big table and I have to search in it. I'm sending queries via Java and then work with the result set. Now when I send a query the result set is so big, that I get java heap overflow. Is there any possibility to deal with such things. Does SQL have any kind of lineID so that I could iterate through the table. If there is no other possibility to solve the problem I have to insert one new column into the table, containing a lineID, which doesn't make me happy, as it will make the table larger again.

Thanks for your help

Options: ReplyQuote

Written By
Iterating through SQL table
April 18, 2009 01:10PM
April 26, 2009 01:06PM
April 26, 2009 11:14PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.