On 2018/03/23 2:56 PM, mansour n wrote:
Hi
Thank you for your response, if I understand you propose that we use "create memory table" ? I'm not sure to understand
the difference between "memory" and "cached" table, the two are persistent and what is the limit when the doc says :
"memory tables should not get too large"
it's not really a limit, just a case of: the index is ALWAYS in RAM, so if you have a large table, your Java VM is going
to always be consuming that memory.
I guess if your table gets big enough, your Java VM will eventually run out of
RAM.
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
