Reply to thread

Message

<blockquote data-quote="htpsd" data-source="post: 127975" data-attributes="member: 27262">Hello Everybody,I was wondering what database I should use. So I set up the server once with MSSQL and once with MySQL. The content of both databases should be exactly the same. I checked it for the Table &quot;program&quot;. In both databases I importet the same data from Clickfinder. 7777 rows are in both databases.Then I wrote a simple PHP Script wich makes 10.000.000 queries on the table &quot;program&quot;. Once for MySQL and once for MSSQL.I ran the script for each database about 10 times to be shure that the result is right.The MSSQL database needed 740 seconds to execute the query.The MySQL database needed 600 seconds to execute the query.Query was: &quot;select * from program&quot; .Than I changed the script to insert data into the databases. Again I choosed the table &quot;program&quot;. I simply added some trash data. The script added 10.000 entries in both databases.The MSSQL database needed 240 seconds to execute the query.The MySQL database needed 255 seconds to exevute the query.--&gt; So for reading MySQL is faster for TVengine3 - for writing MSSQL.In my configuration with 4 clients the TVservice reads more data from database than it writes into it - so I decided to use MySQL.Additional info:-Both databases were set up like its written in the TVengine3 wiki.-This performance test is only for the TVengine Database correct. Other databases could give other results.-The tests run at the same machine. Only Apache and the specific database were running.-The results are averages from about 10 results.-The Server is running MySQL 5.1, MSSQL 2005 Express, PHP5.1 on Dual Core AMD 64 4600+ running on Windows 2003 Enterprise x86 and 4 GB Ram.Queries for MySQL (MSSQL is the same code, but mssql_connect)[CODE]&lt;?php$host = 'localhost';$db&nbsp;&nbsp; = 'tvlibary';$user = 'root';$pw&nbsp;&nbsp; = '***';set_time_limit(3600);$link = mysql_connect($host, $user, $pw);if (!$link) {&nbsp;&nbsp; die('keine Verbindung möglich: ' . mysql_error());}echo 'Verbindung erfolgreich&lt;br&gt;&lt;br&gt;';$que = mysql_select_db($db);$t1 = time();//Queries$i=1;while ($i &lt;= 10000000) {&nbsp; mysql_query(&quot;select * from program&quot;);&nbsp; $i++;}$t2 = time();$t3 = $t2-$t1;echo $t3;?&gt;[/CODE]</blockquote>

[QUOTE="htpsd, post: 127975, member: 27262"] Hello Everybody, I was wondering what database I should use. So I set up the server once with MSSQL and once with MySQL. The content of both databases should be exactly the same. I checked it for the Table "program". In both databases I importet the same data from Clickfinder. 7777 rows are in both databases. Then I wrote a simple PHP Script wich makes 10.000.000 queries on the table "program". Once for MySQL and once for MSSQL. I ran the script for each database about 10 times to be shure that the result is right. The MSSQL database needed 740 seconds to execute the query. The MySQL database needed 600 seconds to execute the query. Query was: "select * from program" . Than I changed the script to insert data into the databases. Again I choosed the table "program". I simply added some trash data. The script added 10.000 entries in both databases. The MSSQL database needed 240 seconds to execute the query. The MySQL database needed 255 seconds to exevute the query. [B]--> So for reading MySQL is faster for TVengine3 - for writing MSSQL. In my configuration with 4 clients the TVservice reads more data from database than it writes into it - so I decided to use MySQL.[/B] Additional info: -Both databases were set up like its written in the TVengine3 wiki. -This performance test is only for the TVengine Database correct. Other databases could give other results. -The tests run at the same machine. Only Apache and the specific database were running. -The results are averages from about 10 results. -The Server is running MySQL 5.1, MSSQL 2005 Express, PHP5.1 on Dual Core AMD 64 4600+ running on Windows 2003 Enterprise x86 and 4 GB Ram. Queries for MySQL (MSSQL is the same code, but mssql_connect) [CODE]<?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 '; $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; ?>[/CODE] [/QUOTE]

Verification