Hi, > how to work out for a given table size how much cache > must be allocated to keep its primary key index in memory?
There is no simple answer for that question. You have to test it yourself. But, again, if you want to keep the whole index in memory you could use "memory tables": http://www.h2database.com/html/grammar.html#create_table > If one knows the average key size and the number of rows in the table, > is it possible to calculate how much memory is required for the > primary key index? No. The best way it to try it out. It depends on too many factors (JVM used and so on). 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.
