Hi, In version 1.2.x (with the page store) there is no way to set the cache size for indexes individually.
If you want to keep the whole index in memory you could use "memory tables": http://www.h2database.com/html/grammar.html#create_table What you could do is create two databases: - One database with a relatively small cache and all the data, but no index except for the primary key. - The second database with a large cache, with a few tables to index the data, and a "linked table" that points to the actual data (in embedded mode). http://www.h2database.com/html/grammar.html#create_linked_table 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.
