Thread: [Squirrel-SQL-announce] heap space
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Howard J. H. <howard@IdeaVillage.com> - 2008-10-01 18:29:38
|
In Squirrel SQL 2.5 I have been unable to allocate more than 64 MB for heap space. I have a table that is over 100,000 records and this is creating a problem for opening/viewing/exporting. What is the syntax for opening Squirrel SQL to grant this amount of memory? I have tried variants of the -Xmx parameter but without success and also changing preferences for viewing different amounts of records but this has eventually caused an error when reaching the heap limit. |
From: Matthew D. <mda...@ja...> - 2008-10-02 01:17:11
|
I've had no problems allocating 256 MB for SQuirreL, so the problem is likely just getting precisely the correct syntax in your startup command. My squirrel-sql.bat file uses this line: start "SQuirreL SQL Client" /B "%LOCAL_JAVA%w" -Xmx256m -cp %TMP_CP% net.sourceforge.squirrel_sql.client.Main %TMP_PARMS% If your main goal is to dump the contents of a table into a file then SQuirreL may not be the simplest solution. Its need to load the data into memory first will be an issue. I would expect that using the database's standard command line tools would more easily let you run a simple query and redirect the result to a file. You didn't specify a database technology, but it would be similar with any database. For example with MySQL you could run a command like this: mysql -u myuser -pmypassword -D foodmart < myquery.sql > result.txt Regards, Matt Dahlman Jaspersoft _____ From: Howard J. Herman [mailto:howard@IdeaVillage.com] Sent: Wednesday, 01 October, 2008 11:07 To: squ...@li... Subject: [Squirrel-SQL-announce] heap space In Squirrel SQL 2.5 I have been unable to allocate more than 64 MB for heap space. I have a table that is over 100,000 records and this is creating a problem for opening/viewing/exporting. What is the syntax for opening Squirrel SQL to grant this amount of memory? I have tried variants of the -Xmx parameter but without success and also changing preferences for viewing different amounts of records but this has eventually caused an error when reaching the heap limit. |
From: Dan D. <dan...@gm...> - 2008-10-02 11:09:08
|
Hey Howard, Have you tried adding the -Xmx parameter to the squirrel-sql.bat / squirre-sql.sh ? I'm using version 2.6.7 and by default it uses now 256 MB for heap, e.g. @rem Run with no command window. This may not work with older versions of Windows. Use the command above then. start "SQuirreL SQL Client" /B "%LOCAL_JAVA%w" -Xmx256m -cp %TMP_CP% net.sourceforge.squirrel_sql.client.Main %TMP_PARMS% HTH, Dan 2008/10/1 Howard J. Herman <ho...@id...> > In Squirrel SQL 2.5 I have been unable to allocate more than 64 MB for > heap space. I have a table that is over 100,000 records and this is > creating a problem for opening/viewing/exporting. What is the syntax for > opening > Squirrel SQL to grant this amount of memory? I have tried variants of the > -Xmx parameter but without success and also changing preferences for viewing > different amounts of records but this has eventually caused an error when > reaching the heap limit. > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's > challenge > Build the coolest Linux based applications with Moblin SDK & win great > prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > Squirrel-SQL-announce mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-announce > > |