[Nepomuk] Query Generator Problem

[Ignacio Serantes]

In my system this query needs almost 2 seconds to be executed but, when you
fixed takes over 30 milliseconds.

On Wed, Apr 4, 2012 at 10:00 AM, Sebastian Trüg <trueg at kde.org> wrote:

> I tried this query. While it is of course pointless to have the
> additional hasTag without a "FILTER(?v2!=?v3)" it does not seem to pose
> a problem to virtuoso here.
>
> What exactly do you mean by "screwing up"?
>
> On 03/20/2012 08:25 PM, Vishesh Handa wrote:
> > Hey Sebastian
> >
> > If you get a chance please look at this -
> >
> >  1.
> >     nepomukqueryservice(21826)/nepomuk (query service)
> >     Nepomuk::Query::SearchRunnable::run: "<?xml version="1.0"?><query
> >     limit="6" offset="0" fullTextScoring="false"
> >     fullTextScoringOrder="desc" flags=""><and><type
> >     uri="http://www.semanticdesktop.org/ontologies/2007/08/15/nao#Tag
> "/><comparison
> >     property="
> http://www.semanticdesktop.org/ontologies/2007/08/15/nao#hasTag"
> >     comparator=":" inverted="true"/><comparison
> >     property="
> http://www.semanticdesktop.org/ontologies/2007/08/15/nao#hasTag"
> >     comparator=":" aggregate="count" sortWeight="1" sortOrder="desc"
> >     inverted="true"/></and></query>
> >  2.
> >     " "select distinct ?r where { { ?r a
> >     <http://www.semanticdesktop.org/ontologies/2007/08/15/nao#Tag> . ?v2
> >     <http://www.semanticdesktop.org/ontologies/2007/08/15/nao#hasTag> ?r
> >     . ?v3
> >     <http://www.semanticdesktop.org/ontologies/2007/08/15/nao#hasTag> ?r
> >     . } . ?r
> >     <
> http://www.semanticdesktop.org/ontologies/2007/08/15/nao#userVisible>
> >     ?v1 . FILTER(?v1>0) . } ORDER BY DESC ( count(?v3) ) LIMIT 6"
> >
> >
> > The query has this twice, and it's screwing up virtuoso -
> >
> > ?v2 <http://www.semanticdesktop.org/ontologies/2007/08/15/nao#hasTag>
> ?r .
> > ?v3 <http://www.semanticdesktop.org/ontologies/2007/08/15/nao#hasTag>
> ?r .
> >
> > Do you think you could update the Query Generator to handle cases like
> this?
> _______________________________________________
> Nepomuk mailing list
> Nepomuk at kde.org
> https://mail.kde.org/mailman/listinfo/nepomuk
>



-- 
Best wishes,
Ignacio
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/nepomuk/attachments/20120404/47ca8cdb/attachment.html>