I am using HSQL with java, HSQL database file size is 3 GB then it need 10 GB heap memory and approx. 5-7 minute database boot time while creating datasource.
Need suggestions to bring down heap memory and startup time, our prod instance is approx 10GB and it requires 30-40 GB RAM and 10 minutes time.
I am using HSQL with java, HSQL database file size is 3 GB then it need 10 GB heap memory and approx. 5-7 minute database boot time while creating datasource.
Need suggestions to bring down heap memory and startup time, our prod instance is approx 10GB and it requires 30-40 GB RAM and 10 minutes time.
Share Improve this question asked Feb 5 at 19:44 ashuashu 11 Answer
Reset to default 0You are using MEMORY tables with all data read and loaded into heap memory at boot time. Your numbers are normal for this type of database.
You can change the type of your large tables to CACHED to reduce heap use. Please read the HSQLDB Guide http://hsqldb.org/doc/2.0/guide/management-chapt.html#mtc_table_types