• Post Reply Bookmark Topic Watch Topic
  • New Topic

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

 
jatandar dhirwani
Greenhorn
Posts: 5
  • 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
  • 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?
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!