Sorry, one more thing:
to make the table and it's indexes live only in memory, you will need:
CREATE MEMORY TABLE .... NOT PERSISTENT
The "MEMORY" part means "keep the indexes in memory, don't use disk for
them"
The "NOT PERSISTENT" part means "don't write the row data to disk"
On 2013-06-20 15:09, Andrei Manz wrote:
One small question. The table created with MEMORY tag, it is
persistent but the updates of the table are made in the memory or are
commited on the disk?
Thanks.
--
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 http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
