Which one is better? I know nothing about data base so is a hard decision!
<?php
$host = 'localhost';
$db = 'tvlibary';
$user = 'root';
$pw = '***';
set_time_limit(3600);
$link = mysql_connect($host, $user, $pw);
if (!$link) {
die('keine Verbindung möglich: ' . mysql_error());
}
echo 'Verbindung erfolgreich<br><br>';
$que = mysql_select_db($db);
$t1 = time();
//Queries
$i=1;
while ($i <= 10000000)
{
mysql_query("select * from program");
$i++;
}
$t2 = time();
$t3 = $t2-$t1;
echo $t3;
?>
This is not a statement that says wich database is the better one.
I just wanted to know wich database is faster for my uses. I posted it because this information could be useful to somebody...
Both databases are good databases. I work everyday with databases (MSSQL, MySQL and PostgreSQL). The performance on any database depends on the hardwarespecs and for what you use it.
I don't think that MP will run slower when I use MSSQL. It's just an info