MySQL Forums
Forum List  »  MySQL Workbench

Re: System.OutOfMemoryException was thrown
Posted by: Mike Lischke
Date: February 19, 2015 02:02AM

Martin,

obviously every softrware has a memory limit and loading only enough data is surely pushing a program to that. So when loading 250K+ rows is giving you an OOM exception you probably hit that limit. What version of WB do you use? You will have better changes with the 64bit version instead of 32bit. But I still recommend not to load such a huge amount of data. Rather use OFFSET and LIMIT in your query to get to specific parts. You rarely need to load *all* data of a table.

Mike

Mike Lischke, MySQL Developer Tools
Oracle Corporation

MySQL Workbench on Github: https://github.com/mysql/mysql-workbench
On Twitter: https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to http://bugs.mysql.com
MySQL documentation can be found here: http://dev.mysql.com/doc/refman/8.0/en/

Options: ReplyQuote


Subject
Views
Written By
Posted
5324
February 18, 2015 01:22PM
Re: System.OutOfMemoryException was thrown
1672
February 19, 2015 02:02AM


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.