Re: Criteria if a database should be embedded

2011-11-16 Thread Adam McMahon
I don't know if there are any strict criteria for embedded vs non-
embedded.

I am running a web app using H2 in embedded mode, and it is working
fine.

I chose embedded mode for the following reasons:

a) it is faster, as connections are within the same JVM and not over
another protocol
b) simple deployment
c) saves some resources, as you do not need to run another JVM

Here are some reasons why you may not want to run in embedded mode

a)  If multiple app servers need to connect to H2
b) If your database accessed so much that it makes sense to put it on
another cpu altogether.
c) management is a bit easier because you can use the web browser
interface, but you can't easily do that when it is in embedded mode
(there is a servlet which should allow you to do this, but I have not
tested it yet).


On Nov 14, 4:11 am, cnn nagesh...@gmail.com wrote:
 What will be the criteria to decide if the database should be embeded?
 I plan to develop a web application which is essentially CRUD and
 reporting style

 thanks
 -cnn

-- 
You received this message because you are subscribed to the Google Groups H2 
Database group.
To post to this group, send email to h2-database@googlegroups.com.
To unsubscribe from this group, send email to 
h2-database+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.



Re: Criteria if a database should be embedded

2011-11-16 Thread Thomas Mueller
Hi,

If performance is very important, you should also use an embedded database
(TCP/IP is quite a large overhead).

Regards,
Thomas

-- 
You received this message because you are subscribed to the Google Groups H2 
Database group.
To post to this group, send email to h2-database@googlegroups.com.
To unsubscribe from this group, send email to 
h2-database+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.



Criteria if a database should be embedded

2011-11-14 Thread cnn
What will be the criteria to decide if the database should be embeded?
I plan to develop a web application which is essentially CRUD and
reporting style

thanks
-cnn

-- 
You received this message because you are subscribed to the Google Groups H2 
Database group.
To post to this group, send email to h2-database@googlegroups.com.
To unsubscribe from this group, send email to 
h2-database+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.



Re: Criteria if a database should be embedded

2011-11-14 Thread Carlos Hoces
Up to my knlowledge, embedding a database is a very convenient choice for
stand alone desktop applications.

Carlos Hoces
jPlay project http://www.javaforge.com/project/jplay

2011/11/14 cnn nagesh...@gmail.com

 What will be the criteria to decide if the database should be embeded?
 I plan to develop a web application which is essentially CRUD and
 reporting style

 thanks
 -cnn

 --
 You received this message because you are subscribed to the Google Groups
 H2 Database group.
 To post to this group, send email to h2-database@googlegroups.com.
 To unsubscribe from this group, send email to
 h2-database+unsubscr...@googlegroups.com.
 For more options, visit this group at
 http://groups.google.com/group/h2-database?hl=en.



-- 
You received this message because you are subscribed to the Google Groups H2 
Database group.
To post to this group, send email to h2-database@googlegroups.com.
To unsubscribe from this group, send email to 
h2-database+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.