• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
jatandar dhirwani
Greenhorn
Posts: 5
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 10336
Eclipse IDE Hibernate Java
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic