reuse database connections
| From: | Support @ Fourthrealm.com | Date: | Thu, 19 Sep 2002 00:44:45 +0000 |
| Subject: | reuse database connections | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-116816@lists.php.net to get a copy of this message | ||
Another question about efficiency / using server resources:
In another language I use, I can re-use an ODBC connection to make further queries/update/etc to the database to save the overhead of closing and reopening the connection to the db over and over.
It works sometime like this (in the other language):
<iSQL DBNAME='xxx' LOGIN='xxx' SQL='some query'> # opens the connection
... display results...<iSQLMORE SQL='some other query'> # reuses the connection
....display other results....</iSQL> # closes the connection Is there an equivalent in PHP to this, using the mySQL set of tags? Peter - - - - - - - - - - - - - - - - - - - - - Fourth Realm Solutions pbechard@fourthrealm.com http://www.fourthrealm.com Tel: 519-739-1652 - - - - - - - - - - - - - - - - - - - - -