Forum:SMW on Familypedia

Hey all, here is a conversation I had with Robin tonight and something I would like the community as a whole to be brought up to speed on: Hello Robin,

There's an excellent reason why your pages weren't displaying on Familypedia for a few hours and that's because we had to turn SMW off there for about a period of three hours. We've been trying to work out a patch because Familypedia was causing massive load on our Apache and MySQL servers. The patch finally took and it was implemented immediately. Pages should be back to normal now.

Robin, we're trying very hard to continue to facilitate your excellent wiki both because we do sincerely want to learn about and improve Semantic MediaWiki so other sites can be a storehouse of information like yours. But the template system you've implemented is insane (I mean that more in the good way than the crude way) and all of those queries and conditions and parameters that you get to handle of this information is simply overwhelming our DBs more and more as more and more content gets added. Frankly, if Familypedia were on its own server, it would have overwhelmed that stand-alone DB server a long time ago. It's a miracle our system has managed to handle this this long.

In other words, there are simply too many blank pages. Too many expensive queries. Too heavily-coded templates. We're going to continue working on this on our end, but this is something you're going to /have/ to address on your end. Those templates need major reworking, even if it means cutting down on some of the functionality, in order for this to continue to work. --daNASCAT (Help Forum) (blog) 04:47, November 13, 2010 (UTC)