Re: [Squirrel-sql-users] exceeded maximum memory

[<erw...@gm...>]

If your table is very large, raising the memory size won't be enough.
You should also limit the number of rows fetched by squirrel. 1000 rows is a good start. 
This can be set in the upper right corner of the sql window and in the general settings.
Sorry not to be more specific, i'm not on my pc.
Erwan


Envoyé depuis mon Archos.



-----Original Message-----
From: Stefan Willinger <ste...@ao...>
To: squ...@li...
Sent: lun., 26 mars 2012 19:24
Subject: Re: [Squirrel-sql-users] exceeded maximum memory

You can increase the max available memory by editing your run script.

Depending on your operating system, you have to edit squirrel-sql.sh or 
squirrel-sql.bat.

Look for the line containing -Xmx256m (usually one of the last lines) 
and change this value to -Xmx512m or -Xmx756m or any other valid value 
(the valid value depends on your OS and Java Version).

Stefan

Am 2012-03-26 16:24, schrieb patricios1:
> Hi,
>
> I keep running out of memory when running queries. I get the following 
> message:
>
> "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."
>
> Can I allocate more memory to the program?  If so, can someone advice 
> how to do that?
>
> Thank you very much,
> Patricio
>
>
> ------------------------------------------------------------------------------
> This SF email is sponsosred by:
> Try Windows Azure free for 90 days Click Here
> http://p.sf.net/sfu/sfd2d-msazure
>
>
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users