In my system this query needs almost 2 seconds to be executed but, when you fixed takes over 30 milliseconds.<br><br><div class="gmail_quote">On Wed, Apr 4, 2012 at 10:00 AM, Sebastian Trüg <span dir="ltr"><<a href="mailto:trueg@kde.org">trueg@kde.org</a>></span> wrote:<br>

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