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.
/dkm
"Randell D." <yo**************************@yahoo.com> wrote in message
news:qakhb.54953$9l5.45409@pd7tw2no...
Folks,
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%
or more activity for ten minutes or so, would the extra connections stay
alive 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?