It depends on your requirements.
For read only load balancing to achieve more performance
you might also consider to use replication:
http://gborg.postgresql.org/project/pgreplication/projdisplay.php
This way you could for exapmle setup 4 instances of
tomcat and 2 instances of postgreSQL where
Try caching first; with Poolman.sf.net or
http://www.phworks-online.com/cache.html
Replication could slow you down.
.V
Ralph Einfeldt wrote:
It depends on your requirements.
For read only load balancing to achieve more performance
you might also consider to use replication:
From: Vic Cekvenich [EMAIL PROTECTED]
Sent: Monday, February 24, 2003 4:02 AM
Subject: Re: Database load balancing?
Try caching first; with Poolman.sf.net or
http://www.phworks-online.com/cache.html
Yeah, that's what I would try first. Especially if it's read only data, make
it an issue
]
Sent: Monday, February 24, 2003 7:54 PM
Subject: RE: Database load balancing?
It depends on your requirements.
For read only load balancing to achieve more performance
you might also consider to use replication:
http://gborg.postgresql.org/project/pgreplication/projdisplay.php
This way you