Please use a connection pool. For Instruction: http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html and http://www.mysql.com/articles/connection_pooling_with_connectorj.html
--- Carlos Pereira <[EMAIL PROTECTED]> wrote: > Hi list, > my application currently uses ONE connection object > to communicate with the database. The connection is > set with an initializer servlet (load_on_stratup=0), > and all users use that connection to retrieve data. > > Is this the best approach, or should i create a > connection per user? Why? Where can i know more? > > The security system works on top of the database, > so that's not a problem. I'm more concerned with > performance and concurrency. > > Regards and thanks, > Carlos Pereira > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]