Author: sergey.chernyshev
Description:
smw_relations table grows very fast. It might be good idea to consider stripping it of subject_namespace and subject_title or even merging it with MediaWiki pagelinks table which apart from relation_title stores all the same information (since relations are defined through links syntax).
For statistics - one of my test installations with about 30K (relation intensive) pages has approximately 5mil entries in smw_relations (taking approximately 1GB of space) table and a little more entries in pagelinks table (taking approximately 850MB of space).
Maillist discussion thread (my posts only, so far) can be seen here:
http://sourceforge.net/mailarchive/forum.php?thread_name=9984a7a70705281206r58d041f9i7c393a82447f1336%40mail.gmail.com&forum_name=semediawiki-devel
Version: unspecified
Severity: normal
URL: http://sourceforge.net/mailarchive/forum.php?thread_name=9984a7a70705281206r58d041f9i7c393a82447f1336%40mail.gmail.com&forum_name=semediawiki-devel