Re: DB package - performance question

On Jul 9, 2008, at 2:24 AM, liran tal wrote:

How does that impact on performance?

So two of the biggest problems with performance with regards to this are: 1.) Authentication - Each of those open connections needs to be authenticated, which is horribly inefficient in MySQL (and most DB's; Oracle is atrocious for instance). 2.) Round Trips - Each time you send an open / close that's another round trip to your DB server (assuming it's on another server). Building up and tearing down connections costs time as does the network latency of sending those requests. A DB connection is a *perfect* use of the singleton pattern. I'd recommend looking that up and using it. :) Good luck! --Joe