Hi, I think you need to read the documentation, specially:
http://h2database.com/html/grammar.html#set_default_table_type http://h2database.com/html/features.html#database_url Regards, Thomas On Sat, Aug 11, 2012 at 5:09 PM, Harish Alwala <[email protected]>wrote: > Hi All > I was using the H2 database as standalone database. Everything was nice > until data in the db is loaded huge data. When I run my application with > such huge database first thing I notice is; the moment I connect to > database whole database is loaded in memory and hence my application slows > down and then fall in to out of memory issues. > I googled a lot to fix issue but I could not get the solution. I dont want > the complete database to be loaded to memory. > > I checked with HSQL DB instead of H2. HSQL has db command as "SET > DEFAULT_TABLE_TYPE CATCHED". This will not load complete db to memory > instead it will load specified number of rows (cache_rows=<int>) into > cache. And my application works exceptionally well with HSQL DB. > > I would like to know if such concept is there in H2, if yes how to get > such feature of HSQL DB in H2? > > Regards > Harish Alwala > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/h2-database/-/hWyJMJpB1sEJ. > 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. > -- 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.
