Need Advice : MySQL Query Analyzer is unable to load all the rows in the table
posted 5 years ago
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.