because odbc_connect takes some time to establish connection while odbc_pconnect establishes it once after that it suppose to give faster access through already existing connection!
that's what I got from php manual.. the bad thing is .. that in reality it works a little bit different.. so I am wondering .. why? "Eric Coleman" <[EMAIL PROTECTED]> wrote in message 026b01c1db1c$860b2890$0201a8c0@devstation">news:026b01c1db1c$860b2890$0201a8c0@devstation... > Why won't you just use odbc_connect ? > ----- Original Message ----- > From: "Maris Kalnins" <[EMAIL PROTECTED]> > To: < > Sent: Wednesday, April 03, 2002 3:07 AM > Subject: [PHP] odbc_pconnect doesnt reuse connection > > > > Hi! > > > > Configuration: WinXP, the latest Apache, PHP4 > > > > The problem is that every time the script runs and the following command > is > > executed > > $cx=odbc_pconnect($G_dbname, $G_dblogin, $G_dbpassw); > > it happens very often that a new connection is created instead of reusing > > the old one! > > > > Is there any idea what's wrong... ? > > > > And another question - when user hits reload or submit button at the > moment > > when > > actually this odbc_pconnect is in progress - it generates another > connection > > leaving the old one > > (half opened or whatever) still alive.. > > > > So if you will click on submit button more than 10 times with a little > short > > interval - > > we will get ODBC error - "Database server connection limit exceeded" > > > > I tried to set in PHP config file > > odbc.max_persistent = 1 > > > > but it still overgoes more than 1 connection to the same database, user > and > > password.. > > > > What's wrong? > > > > > > > > > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
