From: Robert Murphy <mrandmrsmurphy@gm...> - 2011-05-23 09:01:12
So I'm trying to make my ginormous, bloated wiki faster. It's my own fault:
I've got 34k content pages, 254k pages total, 344 properties with 7.7 mil
values. The layout is dumb: There are 34k worth of pages in the main
namespace, which transclude their namesake in five special namespaces. When
I created the wiki, I needed the separate namespaces to do specific
transformations on the data, but I'm (nearly) done.
My question is, what makes the more efficient SMW wiki: a lot of pages with
little data, or a few pages with lots of data?
P.S. /var/log/mysql/mysql-slow.log is full of all the time of things just
# Time: 110523 1:48:54
# User@...: root[root] @ localhost 
# Query_time: 2.694686 Lock_time: 0.000111 Rows_sent: 4 Rows_examined: 5206
SELECT /* SMW::getInProperties 127.0.0.1 */ DISTINCT smw_title,smw_sortkey
FROM 'smw_ids' INNER JOIN 'smw_rels2' AS t1 ON t1.p_id=smw_id WHERE
Semantic Drilldown 0.8.1
Semantic Forms 2.1.1alpha
Get latest updates about Open Source Projects, Conferences and News.