Did I understand correctly that derby.storage.pageCacheSize is configured per database?
Is there a way to set the page cache size for derby across all databases in the JVM when running Derby in embedded mode? Background: We are running Derby in an application where there is one database per client. Eventually we would want to update the database model to allow all clients to be inside a single database, but that is a big undertaking. Derby offers a great solution for us. We use it in embedded mode and have one database per client. However, memory consumption is getting out of hand now that we're reaching hundreds of databases. After taking a heap snapshot and examining memory usage, it looks like it is the page cache that is causing the problem. At any one time there are only a few databases active, so if Derby had a concept of configuring maximum cache usage for the entire JVM, there would not be a problem with the available memory. -- Øyvind Harboe US toll free 1-866-980-3434 / International +47 51 63 25 00 http://www.zylin.com/zy1000.html ARM7 ARM9 ARM11 XScale Cortex JTAG debugger and flash programmer
