MySQL Forums :: Newbie :: Iterating through SQL table


Advanced Search

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

Hallo,

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


Subject Written By Posted
Iterating through SQL table K R 04/18/2009 01:10PM
Re: Iterating through SQL table Peter Brawley 04/18/2009 01:41PM
Re: Iterating through SQL table K R 04/26/2009 01:06PM
Re: Iterating through SQL table Peter Brawley 04/26/2009 04:44PM
Re: Iterating through SQL table K R 04/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.