[
https://issues.apache.org/jira/browse/JENA-800?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14181338#comment-14181338
]
Andy Seaborne commented on JENA-800:
------------------------------------
Bala - either! You can install any {{ReorderTransformation}} as the default to
be used if no {{.opt}} file is found.
The "fixed" algorithm is, by its nature of being data independent, a pragmatic
guess at a sensible order. Teh "stats" form allows you to specify {{VAR
rdf:type <unique type URL>}} as good (statically - you'd need your own code to
do that dynamically).
{{ReorderLib.identity()}} is the code for none.opt.
Or you could install a copy of the old fixed reorder. The stats configurmation
above is taken from the old code.
Give the nature of your example query, it's the first part that is the key to
execution.
You have {{?url dcterms:modified ?modified}} twice, once in the long BGP, once
in the {{OPTIONAL}}.
> 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)
