Re: MySQL and SESSIONs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Vo, Lance wrote:
What's good for multiple webservers? thanks

* DO NOT USE PERSISTANT CONNECTIONS

* Minimise the amount of time you keep a database connection open during a request. Good logic/presentation separation helps a lot here.

* Cache the crap out of everything - don't hit the DB unless you really need to.

-Stut

--
http://stut.net/

-----Original Message-----
From: Stut [mailto:stuttle@xxxxxxxxx]
Sent: Friday, October 05, 2007 4:31 PM
To: Stefano Esposito
Cc: php-general@xxxxxxxxxxxxx
Subject: Re:  MySQL and SESSIONs


Stefano Esposito wrote:
is it somehow possible to store the connection reference obtained from mysql_connect() (note the absence of the "i") in a $_SESSION element?

No. Why would you want to? You'd end up holding on to a database connection even when nothing is using it. If you want to optimise things look at http://php.net/mysql_pconnect but bear in mind that this starts to suck if you scale up to multiple web servers.

-Stut


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux