Hi. I'm a bit different from most of the responders as I use H2 in mostly client-server mode. The setup I use is a dedicated server installation, a Windows machine no less, that starts H2 as a service. My client machines then connect to this server (all Linux or Windows machines, TCP/IP, Java6) and update and retrieve information from the database. Currently, I have about 11 million records that are being accessed simultaneously by around 5 - 8 users. I can tell you that the only bugs / problems I've experienced in related to code I wrote. As far as I can tell, we haven't suffered dataloss with H2, it's response times are excellent (once properly configured) and it is certainly working very well for me.
The trick with running in "server" mode is to allocate enough RAM to the VM (I allocate 1GB) and set the DB Cache to 256mb, this way, the system works fantastically well for me. I'm still using a bit older version of H2 though, 1.1.118 if I'm not mistaken. It works for me and I've used it in smaller C/S applications as well with just as great a result. Best regards Ewald -- 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.
