Re: [Semediawiki-user] Data Export + Drilldown

[Boxer, A. <Aar...@uh...>]

Thanks, good to know.

-----Original Message-----
From: Yaron Koren [mailto:ya...@gm...] 
Sent: Friday, October 29, 2010 6:56 PM
To: Boxer, Aaron
Cc: sem...@li...
Subject: Re: [Semediawiki-user] Data Export + Drilldown

Hi,

The performance depends on how complex the queries are, and on how
much data there is, but in general I think it's pretty good: people
have been able to run simple queries over even millions of rows of
data. Since queries ultimately just translate to SQL queries, all the
typical speedup approaches will help, including using memcached,
putting MySQL on its own server, etc.

-Yaron

On Fri, Oct 29, 2010 at 10:26 AM, Boxer, Aaron <Aar...@uh...>
wrote:
> Hi Yaron,
>
> Thanks very much. I will try that.
>
> You can ignore the drilldown in the subject line, just used it
> in the sense of querying down several levels in the data hierarchy.
>
> What's the performance like on these queries? Compared to simply running
SQL
> on the MySQL database?  Do any users put a memcached layer in front of
> Apache,
> to speed things up?
>
> Cheers,
> Aaron
>
>
> -----Original Message-----
> From: Yaron Koren [mailto:ya...@gm...]
> Sent: Friday, October 29, 2010 1:09 AM
> To: Boxer, Aaron
> Cc: sem...@li...
> Subject: Re: [Semediawiki-user] Data Export + Drilldown
>
> Hi Aaron,
>
> If all you're trying to do is run queries from outside the wiki, you
> don't need any other extensions for it - you can use Special:Ask,
> defined in SMW, as the "API" - if you create a query there and set the
> format to one of the export formats (CSV, JSON etc.), you'll get just
> the data, at a URL that can be accessed externally.
>
> On the other hand, you mentioned "drilldown" in your subject line, and
> I don't know how that fits in with your question.
>
> -Yaron
>
>
> On Thu, Oct 28, 2010 at 5:02 PM, Boxer, Aaron <Aar...@uh...>
wrote:
>> Hello!
>>
>>
>>
>> I am building a mediawiki using semantic forms, and I would like an
> external
>> application to run queries
>>
>> on the wiki over HTTP and return results in xml, or JSON preferably.
>>
>>
>>
>> For example, if I have a list of authors, and then a list of books by
each
>> other, and then a table of contents for each
>>
>> book, I would like to be able to specify the author and book, and pull
out
>> the table of contents.
>>
>>
>>
>> Is this possible?  I have the semantic bundle installed.
>>
>>
>>
>> Thanks!
>>
>>
>>
>> Aaron
>>
>>
>>
>>
>>
>>
>>
>> "In theory there is no difference between theory and practice. But, in
>> practice, there is."
>>
>>
>>
>>
>> This e-mail may contain confidential and/or privileged information for
the
> sole use of the intended recipient.
>> Any review or distribution by anyone other than the person for whom it
was
> originally intended is strictly prohibited.
>> If you have received this e-mail in error, please contact the sender and
> delete all copies.
>> Opinions, conclusions or other information contained in this e-mail may
> not be that of the organization.
>>
>
----------------------------------------------------------------------------
> --
>> Nokia and AT&T present the 2010 Calling All Innovators-North America
> contest
>> Create new apps & games for the Nokia N8 for consumers in  U.S. and
Canada
>> $10 million total in prizes - $4M cash, 500 devices, nearly $6M in
> marketing
>> Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
>> http://p.sf.net/sfu/nokia-dev2dev
>> _______________________________________________
>> Semediawiki-user mailing list
>> Sem...@li...
>> https://lists.sourceforge.net/lists/listinfo/semediawiki-user
>>
>
>
>
> --
> WikiWorks · MediaWiki Consulting · http://wikiworks.com
>
> This e-mail may contain confidential and/or privileged information for the
sole use of the intended recipient.
> Any review or distribution by anyone other than the person for whom it was
originally intended is strictly prohibited.
> If you have received this e-mail in error, please contact the sender and
delete all copies.
> Opinions, conclusions or other information contained in this e-mail may
not be that of the organization.
>
>



-- 
WikiWorks · MediaWiki Consulting · http://wikiworks.com

This e-mail may contain confidential and/or privileged information for the sole use of the intended recipient. 
Any review or distribution by anyone other than the person for whom it was originally intended is strictly prohibited. 
If you have received this e-mail in error, please contact the sender and delete all copies. 
Opinions, conclusions or other information contained in this e-mail may not be that of the organization.