TalkPHP - View Single Post - Connecting to database everytime You make an instance

Village Idiot · 06-14-2010, 03:47 AM

Quote:

Originally Posted by pipesportugal

Hi there VI,

I followed the link You gave me just to arrive to another link on the php.net website that simply disadvices people from using pconnect (persistent connections).

I was decided to change my instruction to mysql_pconnect(), but after reading the contents of that LINK, it made me think a lot, and also I have never really had a problem with my using of mysql_connect(), so I will stick to it.

Thank You for Your suggestion though,
PP

I am not intimately familiar with persistent connections on a mysql server, but when I used them on an IIS server (running SQL Server 2005) it fixed the connection errors we were having. Perhaps Microsoft has done a better job implementing them.

As long as your class is not opening and closing the connection on each query, a large number won't be a problem. But opening and closing them repetitively will cause trouble for you if you get decent traffic.