[
https://issues.apache.org/jira/browse/JENA-800?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14184145#comment-14184145
]
Andy Seaborne edited comment on JENA-800 at 10/25/14 4:06 PM:
--------------------------------------------------------------
Bala - when you say you uses stats.opt, was it for calculated stats via "TDB
Stats" or the copy of what the old fixed optimizer used that I extracted?
was (Author: andy.seaborne):
Bala- when you say you uses stats.opt, was it for calculated stats via "TDB
Stats" or the copy fo what the old fixed optimizer used that I extracted?
> 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)