[ 
https://issues.apache.org/jira/browse/JENA-800?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14180082#comment-14180082
 ] 

Bala Kolla commented on JENA-800:
---------------------------------

Andy - we use the jfs:resourceContext <https://rmserverurl/projects/projectUUID 
to restrict the hits to a certain scope that user has access to or working in 
the context of. 
Regarding "The default is resettable from Java" - do you mean to override the 
optimization to none but using the java code, or do you mean specifying the 
order of optimization using java. For example we know that there are few 
instances where "VAR rdf:type <unique type URL>" will be much more desirable 
than other. In this case we want the optimizer to move this on top vs the other.

Rob
I have tried stats.opt and didn't get the results as good as with none.opt. I 
will try again later sometime this week..


> Query response time severily regressed when upgraded Jena TDB to 2.11.2 from 
> 0.9.4
> ----------------------------------------------------------------------------------
>
>                 Key: JENA-800
>                 URL: https://issues.apache.org/jira/browse/JENA-800
>             Project: Apache Jena
>          Issue Type: Bug
>          Components: ARQ, TDB
>    Affects Versions: Jena 2.11.2
>            Reporter: Bala Kolla
>         Attachments: QueryExecutionLog_Jena_Ver_0_9_4.txt, 
> QueryExecutionLog_Jena_Ver_2_11_2.txt
>
>
> Many queries, that used to take few milliseconds in 0.9.4, are now taking 
> minutes.
> Here is one of the query that's taking few minutes instead of few 
> milliseconds. I will capture the algebra before and after and update this 
> issue once I have that data.
> {noformat}
> PREFIX dcterms: <http://purl.org/dc/terms/>
> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
> PREFIX rrmNav: <http://com.ibm.rdm/navigation#>
> PREFIX jfs: <http://jazz.net/xmlns/foundation/1.0/>
> PREFIX rm: <http://www.ibm.com/xmlns/rdm/rdf/>
> SELECT ?url ?created ?creator ?modified ?modifier ?title ?description ?scope 
> ?etag
> WHERE
> { 
>    GRAPH ?g
>    { ?url rdf:type rm:View .
>      ?url jfs:resourceContext <https://rmserverurl/projects/projectUUID>
>      { ?url dcterms:creator <rmserverurl/user/clmadmin> .
>        ?url rrmNav:scope "private"
>      }
>      UNION
>      { ?url rrmNav:scope "public" }
>     ?url dcterms:created ?created .
>     ?url dcterms:creator ?creator .
>     ?url dcterms:modified ?modified .
>     ?url dcterms:title ?title .
>     ?url dcterms:description ?description .
>     ?url rrmNav:scope ?scope .
>     ?url jfs:etag ?etag
>     OPTIONAL
>     { ?url dcterms:modifier ?modifier }
>     }
> }
> ORDER BY DESC(?modified) DESC(?url)
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to