Hi. The documentation here: http://www.h2database.com/html/features.html#cache_settings
States that: "The size of the cache, as represented by CACHE_SIZE is measured in KB, with each KB being 1024 bytes." When I query the cache size on my recently created database, using: SELECT * FROM INFORMATION_SCHEMA.SETTINGS WHERE NAME = 'info.CACHE_MAX_SIZE'; The value returned is "16", which I would take from the above to be 16KB. However, another discussion here: http://stackoverflow.com/questions/9798896/performance-issues-using-h2-db-in-embedded-mode-with-heavy-load-of-data-in-datab states that: "The cache size of an persistent, embedded H2 database is 16 MB by default." Can anyone confirm whether it is KB or MB? If it is 16KB, I definitely want to increase it. If 16MB, probably not so important. 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 https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
