Re: General Mysql Connect

Ashley Sheridan wrote: > On Wed, 2008-10-29 at 20:12 -0500, Micah Gersten wrote: > >> Waynn Lue wrote: >> >>>> 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"? >>> >>> >>> >> The only overhead of constantly using mysql_select_db is 2 function >> calls to make a query instead of just using the database name in the >> query. However, this should not be that expensive. >> Yes, connections should be available for the whole script if you don't >> destroy them. >> >> Thank you, >> Micah Gersten >> >> > I'm just thinking about how other languages work with regards to > databases. I'm pretty sure that opening extra database connections, > regardless of whether they are on the same server or not, you will incur > extra opcodes. ColdFusion does it with MSSQL, and I'm guessing that PHP > on Windows using MSSQL or MySQL is going to be fairly the same. Linux > could be different, but why would the developers of the connection > driver write totally different code for both OS's? > > > Ash > www.ashleysheridan.co.uk > With MySQL, you don't need a new DB connection to use a second DB. I think that's the problem your having Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com