測試項目

Php+Mysql

Php + Sphinx 全文檢索引擎

所花時間(秒)

代碼

所花時間

代碼

Title like ‘%Fm5%’

0.93

mysql_query('set names utf8');

$sql = "select title? from? documents where? title? like '%Fm5%'";

$start = getmicrotime();

$result = mysql_query($sql) or die(mysql_error());

$end = getmicrotime();

print mysql_num_rows($result).'<br>';

print $end-$start;

0.012

$cl = new SphinxClient ();

//設置連接Sphinx主機名與端口

$start = getmicrotime();

$cl->SetServer('localhost',3312);

$cl->SetMatchMode(SPH_MATCH_ALL);

//搜索模式均采用匹配所有查詢詞模式

$cl->SetLimits(0,100000);

$res = $cl->Query('Fm5', 'dramx_title');

$end = getmicrotime();

print_r($res);?

print $end-$start;

Content Like ‘%中國LED照明市場%’

11.75

mysql_query('set names utf8');

$sql = "select title? from? documents where? content? like '%中國LED照明市場%'";

$start = getmicrotime();

$result = mysql_query($sql) or die(mysql_error());

$end = getmicrotime();

print mysql_num_rows($result).'<br>';

print $end-$start;

0.020

$cl = new SphinxClient ();

//設置連接Sphinx主機名與端口

$start = getmicrotime();

$cl->SetServer('localhost',3312);

$cl->SetMatchMode(SPH_MATCH_ALL);

$cl->SetLimits(0,100000);

$res = $cl->Query('中國LED照明市場', 'dramx_content');

$end = getmicrotime();

print_r($res);?

print $end-$start;

MATCH (content) AGAINST ('無線網卡廠商')

0.93

mysql_query('set names utf8');

$sql = "select title? from documents where MATCH (content) AGAINST ('無線網卡廠商')";

$start = getmicrotime();

$result = mysql_query($sql) or die(mysql_error());

$end = getmicrotime();

print mysql_num_rows($result).'<br>';

print $end-$start;

0.020

$cl = new SphinxClient ();

//設置連接Sphinx主機名與端口

$start = getmicrotime();

$cl->SetServer('localhost',3312);

$cl->SetMatchMode(SPH_MATCH_ALL);

$cl->SetLimits(0,100000);

$res = $cl->Query('無線網卡廠商', 'dramx_content');

$end = getmicrotime();

print_r($res);?

print $end-$start;

MATCH (content) AGAINST ('產業資訊') 并按照 id 排序（Order By id desc）

1.50

mysql_query('set names utf8');

$sql = "select title? from documents where MATCH (content) AGAINST ('產業資訊')? order? by? id? desc";

$start = getmicrotime();

$result = mysql_query($sql) or die(mysql_error());

$end = getmicrotime();

print mysql_num_rows($result).'<br>';

print $end-$start;

0.031

$cl = new SphinxClient ();

//設置連接Sphinx主機名與端口

$start = getmicrotime();

$cl->SetServer('localhost',3312);

$cl->SetMatchMode(SPH_MATCH_ALL);

$cl->SetSortMode(SPH_SORT_EXTENDED, 'id desc');

$cl->SetLimits(0,100000);

$res = $cl->Query('產業資訊', 'dramx');

$end = getmicrotime();

print_r($res);?

print $end-$start;

MATCH (content) AGAINST ('專題報道') 并根據group_id分組(Group By group_id )

1.01

mysql_query('set names utf8');

$sql = "select title? from documents where MATCH (content) AGAINST ('專題報道')? group? by? group_id";

$start = getmicrotime();

$result = mysql_query($sql) or die(mysql_error());

$end = getmicrotime();

print mysql_num_rows($result).'<br>';

print $end-$start;

0.081

$cl = new SphinxClient ();

//設置連接Sphinx主機名與端口

$start = getmicrotime();

$cl->SetServer('localhost',3312);

$cl->SetMatchMode(SPH_MATCH_ALL);

$cl->SetGroupBy('group_id', SPH_SORT_ATTR_DESC,"@group? desc ");

$cl->SetLimits(0,100000);

$res = $cl->Query('專題報道臺', 'dramx');

$end = getmicrotime();

print_r($res);?

print $end-$start;

Content Like ‘%中國LED照明市場%’? order by id desc

52.54

mysql_query('set names utf8');

$sql = "select title? from documents where content? like '%中國LED照明市場%'? order?? by? id? desc";

$start = getmicrotime();

$result = mysql_query($sql) or die(mysql_error());

$end = getmicrotime();

print mysql_num_rows($result).'<br>';

print $end-$start;

0.031

$cl = new SphinxClient ();

//設置連接Sphinx主機名與端口

$start = getmicrotime();

$cl->SetServer('localhost',3312);

$cl->SetMatchMode(SPH_MATCH_ALL);

$cl->SetSortMode(SPH_SORT_EXTENDED, 'id desc');

$cl->SetLimits(0,100000);

$res = $cl->Query(中國LED照明市場', 'dramx');

$end = getmicrotime();

print_r($res);?

print $end-$start;

Content Like ‘%國際Dram報價平臺%’? group by group_id? desc

40.05

$sql = "select title? from documents where content? like '%中國LED照明市場%'? group?? by? group_id";

$start = getmicrotime();

$result = mysql_query($sql) or die(mysql_error());

$end = getmicrotime();

print mysql_num_rows($result).'<br>';

print $end-$start;

0.081

$cl = new SphinxClient ();

//設置連接Sphinx主機名與端口

$start = getmicrotime();

$cl->SetServer('localhost',3312);

$cl->SetMatchMode(SPH_MATCH_ALL);

$cl->SetGroupBy('group_id', SPH_SORT_ATTR_DESC,"@group? desc ");

$cl->SetLimits(0,100000);

$res = $cl->Query('國際Dram報價平臺', 'dramx');

$end = getmicrotime();

print_r($res);?

print $end-$start;

測試項目

SphinxSE

所花時間（秒）

代碼

Title ?包含 ‘Dramexchange 國際Dram報價平臺’

0.045

mysql_query('set names utf8');

$sql = "select c.* from documents as c,sphinx as t where c.id=t.id and t.query='@title 國際Dram報價平臺;mode=extended'";

$start = getmicrotime();

$result = mysql_query($sql) or die(mysql_error());

$end = getmicrotime();

print mysql_num_rows($result).'<br>';

print $end-$start;

Content ?包含 ?國際Dram報價平臺

0.043

mysql_query('set names utf8');

$sql = "select c.* from documents as c,sphinx as t where c.id=t.id and t.query='@content 國際Dram報價平臺;mode=extended'";

$start = getmicrotime();

$result = mysql_query($sql) or die(mysql_error());

$end = getmicrotime();

print mysql_num_rows($result).'<br>';

print $end-$start;

Title、Content 包含無線網卡廠商

0.016

mysql_query('set names utf8');

$sql = "select c.* from documents as c? inner? join?? sphinx as t? on? c.id=t.id ?where ?t.query='包含無線網卡廠商'";

$start = getmicrotime();

$result = mysql_query($sql) or die(mysql_error());

$end = getmicrotime();

print mysql_num_rows($result).'<br>';

print $end-$start;

Title、Content 包含’中國LED照明市場’并按照group_id排序

0.052

mysql_query('set names utf8');

$sql = "select c.* from documents as c? inner? join?? sphinx as t? on? c.id=t.id where t.query='中國LED照明市場;mode=extended;sort=extended:group_id desc'";

$start = getmicrotime();

$result = mysql_query($sql) or die(mysql_error());

$end = getmicrotime();

print mysql_num_rows($result).'<br>';

print $end-$start;

Title、Content 包含’中國LED照明市場’并按照group_id 分組

0.052

mysql_query('set names utf8');

$sql = "select c.* from documents as c? inner? join?? sphinx as t? on? c.id=t.id where t.query='中國LED照明市場;mode=extended;groupby=attr:group_id'";

$start = getmicrotime();

$result = mysql_query($sql) or die(mysql_error());

$end = getmicrotime();

print mysql_num_rows($result).'<br>';

print $end-$start;