This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
The moose likes JDBC and the fly likes Need Advice : MySQL Query Analyzer is unable to load all the rows in the table Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "Need Advice : MySQL Query Analyzer is unable to load all the rows in the table" Watch "Need Advice : MySQL Query Analyzer is unable to load all the rows in the table" New topic
Author

Need Advice : MySQL Query Analyzer is unable to load all the rows in the table

jatandar dhirwani
Greenhorn

Joined: Aug 09, 2007
Posts: 5
HI guys I am having an issue. The table which I want to load the data in MySQL Query Analyzer has over 1 million rows. Every time I execute this query "select * form myJournal" , the operation breaks up in the middle and I get the following message "The memory load of system is extremely high. This is likely because the current result being very large. In order to keep the system responsive record set retrieval has been stopped ": banghead:


Can you suggest me any solution in I get the all the results as the table is moslty used and is dense.

Regards
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

I'm trying to think of an occasion when I would ever want to load 1 million records into memory and can't thin of one. Why do you need this massive result set in memory?


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
GeeCON Prague 2014
 
subject: Need Advice : MySQL Query Analyzer is unable to load all the rows in the table