Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
docs:squirrel_sql:increase_memory [2013/09/24 11:58] – created billhdocs:squirrel_sql:increase_memory [2014/03/03 15:47] (current) billh
Line 1: Line 1:
-====== increase memory ======+====== increase memory in Squirrel SQL ======
   * when exporting query results to Excel .xls file, an error occurred similar to the following ''   * when exporting query results to Excel .xls file, an error occurred similar to the following ''
 The query results have exceeded the maximum amount of memory allocated to this application.  All result tabs have been closed to allow you to save your work and restart the application.'' The query results have exceeded the maximum amount of memory allocated to this application.  All result tabs have been closed to allow you to save your work and restart the application.''
Line 5: Line 5:
   * located the line containing ''-Xmx256m''   * located the line containing ''-Xmx256m''
   * increase the 256 number to whatever you need, such as 768   * increase the 256 number to whatever you need, such as 768
 +
 +My Windows 7 example:<code bat>
 +start "SQuirreL SQL Client" /B "%LOCAL_JAVA%" -Xmx768m -Dsun.java2d.noddraw=true -cp %SQUIRREL_CP% -splash:"%SQUIRREL_SQL_HOME%/icons/splash.jpg" net.sourceforge.squirrel_sql.client.Main %TMP_PARMS%
 +</code>
  • docs/squirrel_sql/increase_memory.1380045527.txt.gz
  • Last modified: 2013/09/24 11:58
  • by billh