My site is slow and I suspect that the
mySQL-connection is the villain.
I'm using this php code (in principle):
$dbHost = "mysql.domain.com";
$dbName = "databasename";
$dbUser = "username";
$dbPasswd = "password";
function dbConnect()
{
global $dbHost, $dbUser, $dbPasswd, $dbName;
mysql_connect( $dbHost, $dbUser, $dbPasswd ) or error( mysql_error() );
mysql_select_db( $dbName );
}
dbConnect();
$contact = mysql_query("SELECT * FROM databasen ORDER BY datetime DESC LIMIT 15") or error( mysql_error() );
while(list($variable1, $variablw2)=mysql_fetch_row($contact))
{
echo "$variable1 $variable2";
}
Does anyone see anything wrong or slowing?
Thanks in advance!
/ Daniel
