TBH, retrieving super large result sets is not something we optimise for.
If you really need that, you can try turn on the LAZY_FETCH feature.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving
H2 doesn't need a lot of memory for plain queries without aggregate and
window functions, large results are stored on the disk automatically. But
queries with aggregate or window functions currently need to load the whole
result into the memory; the only exclusion is the mentioned optimization
On Tuesday, 21 April 2020 13:12:01 UTC+3, MacMahon McCallister wrote:
>
>
>
> On Tuesday, 21 April 2020 11:18:02 UTC+3, Noel Grandin wrote:
>>
>> Which version is this ?
>>
>> And what happens when you remove the dangerous options? (LOG and UNDO_LOG)
>>
>
> Version: 1.4.200.
> Nothing happens if
On Tuesday, 21 April 2020 11:18:02 UTC+3, Noel Grandin wrote:
>
> Which version is this ?
>
> And what happens when you remove the dangerous options? (LOG and UNDO_LOG)
>
Version: 1.4.200.
Nothing happens if i remove the options. I actually tried fiddling with the
options earlier, but it
Which version is this ?
And what happens when you remove the dangerous options? (LOG and UNDO_LOG)
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to