mssql_* overhead
| From: | Philip Thompson | Date: | Wed, 10 Jan 2007 15:47:03 +0000 |
| Subject: | mssql_* overhead | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-246842@lists.php.net to get a copy of this message | ||
Hi.
Does anyone know if the mssql_connect/_init/_bind/etc require a lot of overhead?
I have a page that requires multiple function calls and each of those opens a new connection to the database, performs the necessary actions in stored procedure(s), and then closes the connection. However, I found this to be slower than I was wanting. So I thought, just create one connection and assign it to the SESSION (a global), and in each function that requires a connection, call that SESSION variable. At the end of the page, close the connection and nullify the variable.
Does anyone see a problem with doing it this way? Security concerns? Anything?
Thanks in advance,
~Philip