Hi, Yes, setting cache_size is another option to increase performance. That has worked for me in the past as well.
You might have to try a URL instead of a file path to make memory db work. Did you search for a solution over at the H2 google group? Kind Regards, Nitai On Tue, Dec 22, 2009 at 8:49 PM, gt <[email protected]> wrote: > Dear Nitai, > > Have you tried using CACHE_SIZE=131072 to bump up H2's default cache > from 16MB? In my case I have a web app that only uses H2 for read > access so an in-memory database may make sense. I just can't get > OpenBD to work with the jdbc:h2:mem:[path/db] setting. It will verify > the datasource but when the app tried to make a query it gives an > error saying the table is not found. If I change it back to jdbc:h2: > [path/db] then everything works again. > > --GT > > On Dec 22, 11:01 am, "Nitai @ Razuna" <[email protected]> wrote: >> Hi >> >> My string for H2 looks like this: >> >> <hoststring>jdbc:h2:/absolutepath/db/razuna;AUTO_SERVER=TRUE;IGNORECASE=true;MODE=Oracle;</hoststring> >> >> Thought, not sure if in-memory mode is really great with OpenBD. It >> only supports read db and not >> write:http://www.h2database.com/html/features.html#in_memory_databases >> >> Kind Regards, >> Nitai >> >> > > -- > Open BlueDragon Public Mailing List > http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon > mailing list - http://groups.google.com/group/openbd?hl=en > > !! save a network - please trim replies before posting !! > -- See for yourself how easy it is to manage files today. Join the revolution! Razuna SaaS On-Demand - Hosted Digital Asset Management Solution http://www.razuna.com/ Razuna - Open Source Digital Asset Management http://www.razuna.org/ Follow us on Twitter http://twitter.com/razunahq -- Open BlueDragon Public Mailing List http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon mailing list - http://groups.google.com/group/openbd?hl=en !! save a network - please trim replies before posting !!
