> > 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"?