We are using H2 in Razuna (http://razuna.org) and are pushing it to the limits 
quite a lot. Some people have 80000 records. The developer of H2 just 
implemented a new datastore mechanism that makes H2 even faster. Other then 
that, I have to say there is not much tweaking to do since it is already very 
fast. If you use it as server, then the performance is slightly different.

Also, update to the latest from the H2 website. The one that comes with OpenBD 
is old.

Kind Regards,
Nitai

On Dec 15, 2009, at 4:16 PM, Matthew Woodward wrote:

> On Mon, Dec 14, 2009 at 1:23 PM, gt <[email protected]> wrote:
> Does anyone have experience with performance tuning H2? What settings
> would you suggest?
> 
> For some of these questions you'll probably get faster and potentially more 
> detailed answers on the H2 mailing lists/forums, though maybe others on the 
> list will jump in. I'm definitely curious about this myself since I haven't 
> done enough with H2 yet to have pushed it to its limits.
>  
> 
> The nice thing about using the H2 DB and OBD is that it's a very
> simple and compact package and we can use to quickly spin up new
> instances.
> 
> Yep, definitely one of the attractive things about this combination.
>  
> Anyway, would love to hear what the community thinks and what
> experience / lessons you can share.
> 
> 
> I'm sure many on this list are interested so if you don't find any concrete 
> answers here but do on the H2 list, be sure and report back! Thanks. 
> 
> -- 
> Matthew Woodward
> [email protected]
> http://mpwoodward.posterous.com
> identi.ca/Twitter: @mpwoodward
> 
> Please do not send me proprietary file formats such as Word, PowerPoint, etc. 
> as attachments.
> http://www.gnu.org/philosophy/no-word-attachments.html
> 
> -- 
> 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

Attachment: smime.p7s
Description: S/MIME cryptographic signature

Reply via email to