Hi Borja, Thank you very much for sharing your experiences with us. Is very useful information for designing the implementation of new projects and save a lot of experimentation.
Your typical JMS load are many small/simple transactions with high peaks over average demand , right ? In regard with your issue, have you tested with MULTI_THREADED in place of MVCC ? In general we have smooth performance with MT than MVCC , but both together would be the ideal. In return I can tell you, that we do have replaced the main (front-end) database with H2 in four mid size web-apps with results that exceeded our expectations. We use DBCP to run H2 in embedded mode as an application server datasource on SLES11 and other linux all with ext3 fs . Performance gain, self containment, traffic off-load and integration level with java applications was our main motivation and all our goals has been satisfied. Regards, Dario El 25/08/10 07:10, Borja escribió: > Hi Dario, > > We're using H2 as storage back-end for JMS. JBoss uses HSSQL by > default, but we had a lot of problems with it, so we searched many > options to replace it and after some tests we decided to use H2. We're > using it on a Red Hat EL 5 with ext3 as filesystem. I tested several > parameters in the connection string, and for us nioMapped was slightly > faster than nio and much faster than regular fs. > > We're using it in production already, appart from little problems it's > behaving quite well. But we're not using it as our main DB, only as > JMS back-end. > > I hope this helps. > > Regards. > > On Aug 24, 8:25 pm, Dario Fassi <[email protected]> wrote: >> Hi Borja, >> Apart from the reported issue, you may tell us about your experience with >> the use of nioMappedFs ? >> I'm interested in base OS used, performance comparison with regular FS and >> motivation to use it. >> Are you using this in production or testing ? >> >> regards >> Dario > -- 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.
