Augusta ENT wrote:
What is the difference between the embedded database and the server
database?

The server database involves you actually starting up H2 and running it as a server, whereas the embedded database just involves you having the H2 jar file in your classpath and then the databases themselves are all file based.

I looked at all of out Sql Server tables for all of our applications and we
have under 1 g of data stored and about 120 users
accessing this data on a daily basis.  It is small but used very frequently
during the day.

I can give you more details on the applications if you like.

Sounds like either would work--Nitai has a lot more experience with H2 than I do. The embedded option is certainly simpler and sounds like it would handle that kind of load quite nicely, but hopefully Nitai will jump in and give his opinion.

--
Matt Woodward
[EMAIL PROTECTED]
http://www.mattwoodward.com/blog

Please do not send me proprietary file formats such as Word, PowerPoint, etc. 
as attachments.
http://www.gnu.org/philosophy/no-word-attachments.html

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature

Reply via email to