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 <[email protected]> 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 > [email protected] > https://mail.kde.org/mailman/listinfo/nepomuk > -- Best wishes, Ignacio
_______________________________________________ Nepomuk mailing list [email protected] https://mail.kde.org/mailman/listinfo/nepomuk
