docs:squirrel_sql:increase_memory

increase memory in Squirrel SQL

  • 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.
  • find the .sh or .bat file wherever Squirrel SQL is installed
  • located the line containing -Xmx256m
  • increase the 256 number to whatever you need, such as 768

My Windows 7 example: 

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%
  • docs/squirrel_sql/increase_memory.txt
  • Last modified: 2014/03/03 15:47
  • by billh