Hello,
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.
Tilmann Brenk
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
|