[RESOLVED] mysql link connection to php

[OwenTheSamoan]

This may seem like a stupid question, but I'll ask anyway. I'm curious to know what is faster when connecting your database to php code. Is it faster to add a link connection $link to your php queries like I have here, or is it faster not to use a link to connect and let the coding search for any available open connection.

$link = @mysql_pconnect('mysql.domain.com', 'something', 'somethingelse')
or die ('Could not connect');
@mysql_select_db('database', $link)
or die ('Could not select database');

mysql_query("select something from table where something='$something'", $link);

[jeremyphphaven]

Create a PHP timer (google it) and check it out for yourself. =O)

start time, query, echo time.

Do it again for second go without referencing the link.

[laserlight]

Is it faster to add a link connection $link to your php queries like I have here, or is it faster not to use a link to connect and let the coding search for any available open connection.

In terms of efficiency, it probably does not matter. More importantly, using $link allows for multiple connections.

That said, I suggest switching from the MySQL extension to the MySQLi extension or the more flexible PDO extension. If you use the object based interfaces these extensions provide this question would not even come up.

[OwenTheSamoan]

Thank you!