Re: Whether i can make one connection for entire web application ?
Wednesday, September 21, 2005 12:54 PM
This is not recommended as it could lead to serious performance problems. Even if you synchronize the use of the connection, others parts of your application will be idle while the wait to use the database.
Don't forego good design (connection pooling) just because it looks difficult to configure or implement. Most web/app servers provide fairly easy setup for this.