Hi, Thanks for your reply and help. The web application I am talking about is a Learning Management System. By simultaneous users I mean that all 2000 users should be able to access the application and for example say take a test. We are using JNDI connection pooling. I think we have to now think about upgrading the hardware as well. thanks for your time. regards Shiva --- Bill Moran <wmoran@xxxxxxxxxxxxxxxxxxxxxxx> wrote: > In response to "Joshua D. Drake" > <jd@xxxxxxxxxxxxxxxxx>: > > > Bill Moran wrote: > > > In response to Shiva Sarna > <shiva.sarna@xxxxxxxxx>: > > > > > >> Hi, > > >> > > >> I am working on a web application where the > front end is struts framework > > >> and back end is PgSQL 7.4. > > > > *cough*, you are going to greatly decrease your > ability to scale if you > > are running anything less than 8.1. > > > > > > Performance _will_ degrade if all of those > connections are busy at once, but > > > that's going to happen with any shared system. > The disk can only read from > > > one area at a time, and other system resources > will be contended for as well. > > > > 7.4 doesn't scale to what he wants, even on big > hardware. > > Oops ... didn't notice that. > > -- > Bill Moran > Collaborative Fusion Inc. > __________________________________________________________ Yahoo! India Answers: Share what you know. Learn something new http://in.answers.yahoo.com/
