| re: mysql_pconnect() Do persistent connections ever die?
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." <you.can.email.me.at.randelld@yahoo.com> wrote in message
news:qakhb.54953$9l5.45409@pd7tw2no...[color=blue]
>
> 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%[/color]
or[color=blue]
> more activity for ten minutes or so, would the extra connections stay[/color]
alive[color=blue]
> 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?
>
>[/color]
| 
