Show pageOld revisionsBacklinksBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ====== 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:<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.txt Last modified: 2014/03/03 15:47by billh