[Helma-user] Java heap space in dbh.query()

[Julian Tree]

  Thanks Joshua,
> set JAVA_OPTIONS=-server -Xmx128m
>
This did the trick.
>
> 1) Don't get 3000 records. Humans can't usually make use of so many
> anyway--is there a way you could use limit clauses to offer paged
> results or something instead?
>

This is a very special situation.  The client specifically want to  
see all the records on one page for invoice printing.  Unfortunately  
the application was not mapped, cause it was being ported from PHP,  
and there are still some stored procedure and trigger running in the  
PostgreSQL backend.  So using the helma ORM is not an option.  Thanks  
for the tip on increasing the memory that is what I needed.

Julian Tree


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://helma.org/pipermail/helma-user/attachments/20070723/71b8c8c4/attachment.html