[SMW-devel] optimizing SMW

2010-03-01 Thread don undeen
hi all, I've got a semantic mediawiki installation with about 100,000 pages and growing, 236k rows in smw_ids, and 646k rows in pagelinks running on Windows Server 2008, MediaWiki 1.13.5 PHP 5.3.1 MySQL 5.1.41 SMW 1.4.2 SMWHalo 1.4.5 I'm getting to the point where page loads are starting to be

Re: [SMW-devel] optimizing SMW

2010-03-01 Thread don undeen
all great advice, thanks! yeah, my jobqueue does get ridiculous, because I'm using externalData calls, and properties that automatically create pages, which have their own externalData calls, etc etc. All managed basically through the refreshLinks and runJobs maintenance scripts. So I've got

Re: [SMW-devel] optimizing SMW

2010-03-01 Thread Thomas Fellows
Hey -- the different charsets, if i remember correctly, had to do with one table/index had latin1, the other had binary, and there was a join statement that wasn't using an index as found by Explain, even though it could find it. One index was in, say, Latin1, and the other was in binary, and so