Re: General Mysql Connect
| From: | Waynn Lue | Date: | Thu, 30 Oct 2008 01:00:09 +0000 |
| Subject: | Re: General Mysql Connect | ||
| References: | 1 2 3 4 5 6 7 8 9 10 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-282603@lists.php.net to get a copy of this message | ||
>
> With MySQL, you can change the DB from query to query with
> mysql_select_db. The alternative as I stated in my last post is to use
> the fully qualified table name (database.table) in your query. MySQL
> doesn't care which DB you have open if you do that. In both of these
> cases, the same connection is used.
>
That brings me back to the original point, is there a performance decrease
to continually calling mysql_select_db? And shouldn't connections that are
being made during the processing of a php script (which runs for no more
than two seconds) be lasting at least until the end of the script, instead
of getting errors like "Lost connection to server"?