we often use squirrel to export the
result of a query to Excel or CSV. But in order to export the results,
we first need to display them.
With large datasets this can lead to
memory problems (insufficient java heap space).
As far as I know I cannot write a query
and then pipe the query results directly into a file.
But I think this would be a very useful
option and could possibly prevent these memory problems.
P.S. I know I can configure squirrel
to use more heap space, but this is not always sufficient.
Kaimer GmbH & Co. Holding KG
Kommanditgesellschaft mit Sitz in Essen · Amtsgericht Essen · HRA 6843
Kaimer GmbH · Geschäftsführer: Bernd Kaimer, Frank Schrick
Amtsgericht Essen · HRB 13343