Hi. I'm PHP newbie and I'm learning how to use MySQL with PHP. I recently learned about mysql_pconnect() function. I checked the PHP manuel about it but couldn't be sure about it's use. I understand that it leaves connection open even when you finish your query/job and this is what bugs me. Is it logical to use it like this, leaving connection open and like that?
I'm a PHP newbie but I'm not new to server-side scripting and databases. I'm developing ASP pages for a long time (and recently started to use ASP.NET) and I use Microsoft SQL Server all the time. My past experiences tought me that leaving a connection like this is not a ver wise move.
So, what do you think about it? When should I use pconnnect and when not? I'd be glad to hear your opinions about it.