It all depends on the database you are connecting to and its configuration.
Many databases will kill inactive threads after a defined unit of time. You
can also configure the max number of connections on many databases as well.
The negative effect of unused connections is wasted resources (memory).
There is a threshold where too many connections can cause problems. It all
depends on your database, OS, and hardware.
Tuning your database and good database design can go a long way in enhancing
performance of your PHP application.
"Randell D." <you.can.email.me.at.randelld> wrote in message
> I currently connect to my db with PHP code that uses non-persistent
> connections. I've read that persistent connections can help performance
> since a connection to the db will use an existing unused connection.
> If my system was to go through a busy period whereby I seen an extra 50%alive> more activity for ten minutes or so, would the extra connections stay> for ever or is there a time limit of inactivity?
> Would the unused connections just sleep if they don't die? Is there any
> negative effect of having these connections waiting around?
> Thanks - all help via the ng would be much appreciated...
> A: Because it messes up the order in which people normally read text.
> Q: Why is top-posting such a bad thing?
> A: Top-posting.
> Q: What is the most annoying thing on usenet?