作者:敖士伟
二、代码
三、测试结果
四、结果分析
PHP和mysql在同一server上
(2)调用WebService代码
Requests per second: 334.20 [#/sec] (mean)
Time per request: 29.922 [ms] (mean)
Time per request: 2.992 [ms] (mean, across all concurrent requests)
Transfer rate: 133.87 [Kbytes/sec] received
(2)调用WebService
Requests per second: 184.51 [#/sec] (mean)
Time per request: 54.197 [ms] (mean)
Time per request: 5.420 [ms] (mean, across all concurrent requests)
Transfer rate: 72.39 [Kbytes/sec] received
Requests per second: 318.36 [#/sec] (mean)
Time per request: 157.053 [ms] (mean)
Time per request: 3.141 [ms] (mean, across all concurrent requests)
Transfer rate: 127.99 [Kbytes/sec] received
(2)调用WebService
Requests per second: 182.86 [#/sec] (mean)
Time per request: 273.427 [ms] (mean)
Time per request: 5.469 [ms] (mean, across all concurrent requests)
Transfer rate: 71.63 [Kbytes/sec] received
(((334.20+318.36)/2)/((184.51+182.86)/2)-1)*100%
可能的原因:
1. 调用WebService增加了网络连接成本
2. 调用WebService在.net端和php都增加了对象的序列化计算成本
索 引
一、环境
二、代码
三、测试结果
四、结果分析
说明:php调用.net WebService,解决返回消息格式问题,比如数据库查询结果。本方案将.net DataTable序列化为JSON返回给php,php使用json_decode()解码JSON数据为数组。
一、环境
1. dotNet环境
Win2003EE sp2,IIS 6.0,.NET 3.5 sp12.PHP环境
CentOS 6.2, Apache 2.2.21, PHP 5.3.8, APC 3.1.9,mysql 5.5.16PHP和mysql在同一server上
3.测试工具
Apache ab.exe二、代码
注:mysql连接都使用持久连接1.dotNet代码
[WebMethod]
public string dsMysql()
{
DataSet dataset = new DataSet();
MySqlConnection conn = new MySqlConnection("Database=test;User Id=root;Password=ikmbikmb;Data Source=192.168.1.121;Port=3306;Pooling=true;Max Pool Size=10;Min Pool Size=1");
MySqlDataAdapter adapter = new MySqlDataAdapter();
adapter.SelectCommand = new MySqlCommand("SELECT * FROM t1", conn);
adapter.Fill(dataset);
JSON_Class Object_JSON_Class = new JSON_Class();
string tb = Object_JSON_Class.CreateJsonParameters(dataset.Tables[0]);
return tb;
}
2.php代码
(1)直接查询mysql代码<?php
$link = mysql_pconnect("192.168.1.121", "root", "ikmbikmb")
or die("Could not connect : " . mysql_error());
mysql_select_db("test") or die("Could not select database");
$query = "SELECT * FROM t1";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
print "<table>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
print "\t<tr>\n";
foreach ($line as $col_value) {
print "\t\t<td>$col_value</td>\n";
}
print "\t</tr>\n";
}
print "</table>\n";
mysql_free_result($result);
mysql_close($link);
?>
(2)调用WebService代码
<?php
$objSoapClient = new SoapClient("http://192.168.1.119/Service1.asmx?WSDL");
$out=$objSoapClient->dsMysql();
$json=$out->dsMysqlResult;
$t=json_decode($json, true);
$t=$t['Head'];
print "<table>\n";
foreach ($t as $line) {
print "\t<tr>\n";
foreach ($line as $col_value) {
print "\t\t<td>$col_value</td>\n";
}
print "\t</tr>\n";
}
?>
三、测试结果
说明:只列出结果关键参数1.第一组测试10个并发
(1)直接查询Requests per second: 334.20 [#/sec] (mean)
Time per request: 29.922 [ms] (mean)
Time per request: 2.992 [ms] (mean, across all concurrent requests)
Transfer rate: 133.87 [Kbytes/sec] received
(2)调用WebService
Requests per second: 184.51 [#/sec] (mean)
Time per request: 54.197 [ms] (mean)
Time per request: 5.420 [ms] (mean, across all concurrent requests)
Transfer rate: 72.39 [Kbytes/sec] received
2.第二组测试50个并发
(1)直接查询Requests per second: 318.36 [#/sec] (mean)
Time per request: 157.053 [ms] (mean)
Time per request: 3.141 [ms] (mean, across all concurrent requests)
Transfer rate: 127.99 [Kbytes/sec] received
(2)调用WebService
Requests per second: 182.86 [#/sec] (mean)
Time per request: 273.427 [ms] (mean)
Time per request: 5.469 [ms] (mean, across all concurrent requests)
Transfer rate: 71.63 [Kbytes/sec] received
四、结果分析
直接查询比调用WebService大概快77%(((334.20+318.36)/2)/((184.51+182.86)/2)-1)*100%
可能的原因:
1. 调用WebService增加了网络连接成本
2. 调用WebService在.net端和php都增加了对象的序列化计算成本