UK WEB HOSTING FORUM FOR DISCUSSION ON WEB HOSTING SERVICE AND SUPPORT
LINUX HOSTING WINDOWS HOSTING PACKAGES SHOPPING CART OSCOMMERCE ZEN CART AGORA
ECOMMERCE HOSTING ASP MSSQL FRONTPAGE HOSTING PHP MYSQL HOSTING DISCUSSION FORUM
CPANEL RESELLER HOSTING DEDICATED SERVER VPS HOSTING PLESK VIRTUOZZO
Quick Search
Your forum announcement here!

  UK Web Hosting | Dedicated Server Windows and Linux VPS Forum > Web Hosting and Domains > PHP Hosting

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 16-08-2007, 17:53
new member
 
Join Date: Aug 2007
Posts: 2
Default Why is MySQL_pconnect disabled?

All of my scripts previously used mysql_pconnect instead of mysql_connect. I was told, by one of the men who helped develop PHP incidentally, that pconnect should always be used. He is also baffled as to why this would be disabled.

So I might as well air this issue and see if anyone else is annoyed by it.
Reply With Quote
  #2 (permalink)  
Old 16-08-2007, 20:40
Premium Member
 
Join Date: May 2006
Location: Cambridgeshire
Posts: 388
Default

It's a slight pain as Dreamweaver adds mysql_pconnect when connecting to databases. Still it's a fairly easy modification to make. I've no idea what the difference is between the two.
__________________
If it ain't broke continue to fix it until it is.
Some cheap plugs... ...IkonForums... ...StNeotsFC... ...Riverside Theatre Company
Reply With Quote
  #3 (permalink)  
Old 16-08-2007, 22:13
DavidAllen's Avatar
Premium Member
 
Join Date: Jan 2007
Location: Amersham
Posts: 330
Send a message via MSN to DavidAllen Send a message via Skype™ to DavidAllen
Default

Think pconnect holds a permament connection whilst connect isn't. A permanent one can hog up the server if it isn't released properly, so I think that's probably why.
__________________
David Allen - www.serina.co.uk
Reply With Quote
  #4 (permalink)  
Old 16-08-2007, 22:46
eUKhost.com's Avatar
Chief Marketing Officer
 
Join Date: Sep 2005
Posts: 4,253
Send a message via AIM to eUKhost.com Send a message via MSN to eUKhost.com
Default

Quote:
Originally Posted by DavidAllen View Post
Think pconnect holds a permament connection whilst connect isn't. A permanent one can hog up the server if it isn't released properly, so I think that's probably why.
You are right.

pconnect is for persistent connection. All such connections stay open even if the query is completely executed and they remain in RAM of the server unless you don't restart MySQL service.

there's no difference in results generated by mysql_connect and mysql_pconnect string.
__________________
UK Web Hosting || Business Hosting || eUKhost Knowledgebase
Toll Free : 0808 262 0255 || MSN : mark @ eukhost.com || AIM : eukmark
A bunch of Sheep led by a Lion is better than a bunch of Lions led by a Sheep.
__________________________________________________

Great Opportunity :: Join our Affiliate Program for FREE and earn 20% commission on each referral.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT. The time now is 02:58.

 

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
LinkBacks Enabled by Web Hosting 3.1.0
Copyright © 2001-2008, eUKhost.com. All rights reserved.

 
Site Map

knowledgebase articles

popular blog categories