> Any advice for tuning a database "in-memory mode" is welcome. These tips are not in the documentation yet, but will be at some point.
For performance and compact storage, prefer the Double and Real types rather than Decimal when not dealing with currency. Watch your memory use -- it is entirely too easy to get an OutOfMemoryError when working with the memory modes if the table gets too big. There are posts in the groups on various ways to avoid this. In general, you should limit the number of rows and size of per- row data. To prevent memory problems, Varchar/char, binary, and LOB types should have hard limits on precision. My previous post on estimating memory use is not fully accurate -- I have better information from source diving now, but hesitate to post since the page store will change this. Regards, Bob McGee --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
