Forget my previous post. The problem goes away when I removed one
template. It seems the performance issue is related to the application
instead of the database.
________________________________
From: Wang, Alex (NIH/CIT) [E]
Sent: Thursday, December 27, 2007 4:46 PM
To: semediawiki-devel@lists.sourceforge.net
Subject: [SMW-devel] SMW performance
It is very slow (30 seconds) to open any pages including "Main Page".
Checking the processes in mysqld found the following sql statements for
each page respectively. I guess `prop11`, `prop8`, `cats6` are temporary
tables, which make it hard to tune these statements.
Does anyone know if these statements look alright? Your help are greatly
appreciated.
SELECT DISTINCT `page`.page_title as title, `page`.page_namespace as
namespace, `page`.page_id as id FROM `prop11`, `prop8`, `cats6`, `page`
INNER JOIN `categorylinks` AS cl5 ON cl5.cl_from=`page`.page_id INNER
JOIN `smw_relations` AS rel7 ON rel7.subject_id=`page`.page_id LEFT JOIN
`redirect` AS rd9 ON rd9.rd_from=rel7.object_id INNER JOIN
`smw_relations` AS rel10 ON rel10.subject_id=`page`.page_id LEFT JOIN
`redirect` AS rd12 ON rd12.rd_from=rel10.object_id WHERE
((`page`.page_namespace='0') OR (`page`.page_namespace='6')) AND
((cats6.title=cl5.cl_to) AND (prop8.title=rel7.relation_title AND
((rel7.object_title='Main_Page' AND rel7.object_namespace=0) OR
(rd9.rd_title='Main_Page' AND rd9.rd_namespace=0))) AND
(prop11.title=rel10.relation_title AND ((rel10.object_title='Parotid'
AND rel10.object_namespace=0) OR (rd12.rd_title='Parotid' AND
rd12.rd_namespace=0)))) LIMIT 51
SELECT DISTINCT `page`.page_title as title, `page`.page_namespace as
namespace, `page`.page_id as id FROM `prop11`, `prop8`, `cats6`, `page`
INNER JOIN `categorylinks` AS cl5 ON cl5.cl_from=`page`.page_id INNER
JOIN `smw_relations` AS rel7 ON rel7.subject_id=`page`.page_id LEFT JOIN
`redirect` AS rd9 ON rd9.rd_from=rel7.object_id INNER JOIN
`smw_relations` AS rel10 ON rel10.subject_id=`page`.page_id LEFT JOIN
`redirect` AS rd12 ON rd12.rd_from=rel10.object_id WHERE
((`page`.page_namespace='0') OR (`page`.page_namespace='6')) AND
((cats6.title=cl5.cl_to) AND (prop8.title=rel7.relation_title AND
((rel7.object_title='Monobook.css' AND rel7.object_namespace=0) OR
(rd9.rd_title='Monobook.css' AND rd9.rd_namespace=0))) AND
(prop11.title=rel10.relation_title AND ((rel10.object_title='Parotid'
AND rel10.object_namespace=0) OR (rd12.rd_title='Parotid' AND
rd12.rd_namespace=0)))) LIMIT 51
SELECT DISTINCT `page`.page_title as title, `page`.page_namespace as
namespace, `page`.page_id as id FROM `prop11`, `prop8`, `cats6`, `page`
INNER JOIN `categorylinks` AS cl5 ON cl5.cl_from=`page`.page_id INNER
JOIN `smw_relations` AS rel7 ON rel7.subject_id=`page`.page_id LEFT JOIN
`redirect` AS rd9 ON rd9.rd_from=rel7.object_id INNER JOIN
`smw_relations` AS rel10 ON rel10.subject_id=`page`.page_id LEFT JOIN
`redirect` AS rd12 ON rd12.rd_from=rel10.object_id WHERE
((`page`.page_namespace='0') OR (`page`.page_namespace='6')) AND
((cats6.title=cl5.cl_to) AND (prop8.title=rel7.relation_title AND
((rel7.object_title='Protein_Clusters' AND rel7.object_namespace=0) OR
(rd9.rd_title='Protein_Clusters' AND rd9.rd_namespace=0))) AND
(prop11.title=rel10.relation_title AND ((rel10.object_title='Parotid'
AND rel10.object_namespace=0) OR (rd12.rd_title='Parotid' AND
rd12.rd_namespace=0)))) LIMIT 51
SELECT DISTINCT `page`.page_title as title, `page`.page_namespace as
namespace, `page`.page_id as id FROM `prop11`, `prop8`, `cats6`, `page`
INNER JOIN `categorylinks` AS cl5 ON cl5.cl_from=`page`.page_id INNER
JOIN `smw_relations` AS rel7 ON rel7.subject_id=`page`.page_id LEFT JOIN
`redirect` AS rd9 ON rd9.rd_from=rel7.object_id INNER JOIN
`smw_relations` AS rel10 ON rel10.subject_id=`page`.page_id LEFT JOIN
`redirect` AS rd12 ON rd12.rd_from=rel10.object_id WHERE
((`page`.page_namespace='0') OR (`page`.page_namespace='6')) AND
((cats6.title=cl5.cl_to) AND (prop8.title=rel7.relation_title AND
((rel7.object_title='HSPP_Cluster:00000067' AND rel7.object_namespace=0)
OR (rd9.rd_title='HSPP_Cluster:00000067' AND rd9.rd_namespace=0))) AND
(prop11.title=rel10.relation_title AND ((rel10.object_title='Parotid'
AND rel10.object_namespace=0) OR (rd12.rd_title='Parotid' AND
rd12.rd_namespace=0)))) LIMIT 51
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Semediawiki-devel mailing list
Semediawiki-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
