[SMW-devel] mysql optimizations? long runtime on inserts

2009-04-14 Thread Michael Dale
When doing an edit on our metavid.org site the following query takes up to 70 seconds: INSERT /* SMW::makeSMWPageID */ INTO `smw_ids` ( smw_id, smw_title, smw_namespace, after it runs it only takes a fraction of a second to insert the next edit you do. Has anyone else run into this issue and ha

Re: [SMW-devel] Missed smw_attributes and smw_relations (and other?) tables

2009-03-25 Thread Michael Dale
In mediaWiki proper this generally handled with hooks and callback something so semantic wiki could be patched.. and do something like the following in Halos setup: $wgHooks['smwfGetStore'][] = 'getHaloStore'; //in the hook function in Halo: function getHaloStore( &$smwgMasterStore ){ $smwgM

Re: [SMW-devel] inserting semantic data

2008-09-24 Thread Michael Dale
suggestion? > > Thanks in advance. > > best regards > Andreas > > Michael Dale wrote: >> I had to edit function edit Updates in Article.php added: >> >> $dbw = wfGetDB( DB_MASTER ); >> $dbw->begin(); # Update the links tables >>$u = new Links

Re: [SMW-devel] inserting semantic data

2008-09-23 Thread Michael Dale
I had to edit function edit Updates in Article.php added: $dbw = wfGetDB( DB_MASTER ); $dbw->begin(); # Update the links tables $u = new LinksUpdate( $this->mTitle, $editInfo->output ); $u->doUpdate(); $dbw->commit(); to commit semantic and category updates made with api base

[SMW-devel] combined SQL queries with smw 1.2

2008-08-16 Thread Michael Dale
I do sql queries that do selects with lots of results across several custom tables. To pull in semantic data I would add the following to mediaWikis database abstraction query variables: (assuming I have a bunch of mv_index_page results as part of a complex join query and wanted property like "s

[SMW-devel] public methods for SMWAskPage?

2008-04-02 Thread Michael Dale
one feature on the metavid site is outputting ask queries to pod-cast like rss feeds: for example a query like: http://tinyurl.com/2w4jz4 has a corresponding rss feed: http://tinyurl.com/2kwt57* *this requires that SMW_SpecialAsk.php make $m_querystring, $m_params,$m_editquery, $m_printouts pub

[SMW-devel] MetaVidWiki Open Beta

2008-03-17 Thread Michael Dale
Hello, MediaWiki Semantic Wiki community I just wanted to announce that the metavidWiki project is now in open beta: http://metavid.ucsc.edu/blog/2008/03/13/metavidwiki-open-beta/ It makes heavy use of the Semantic Wiki extension. Both for simple search gui where you can can visually construct q

[SMW-devel] metavidWiki: Semantic Temporal audio/video metadata

2007-12-18 Thread Michael Dale
If anyone is interested in open source semantic temporal audio/video metadata in mediaWiki take a look at the metavidWiki extension. I just posted a screen cast ... still a few weeks away from public launch but you can check out the preview now: http://metavid.ucsc.edu/blog/2007/12/18/short-met