Hi, >> CREATE MEMORY TABLE > You're perfectly safe, but recreating the index & rebuilding > from the log after an unclean shutdown may be very slow for large > tables. > b)AFAIK you cannot control how much heap a MEMORY table uses, except > by limiting how many rows it has.
Exactly. The indexes are kept fully in memory, and with the indexes some of the data. It doesn't really work for large tables, except if you have a lot of memory, and don't mind if opening the database is slow. > Using a very large > cache_size (yes, that was right) should give similar results to using > a memory table. This would be the preferred option. Regards, Thomas --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
