[
https://issues.apache.org/jira/browse/JENA-800?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14178446#comment-14178446
]
Bala Kolla commented on JENA-800:
---------------------------------
Once I disabled the optimizations using none.opt, this query ( and other
queries similar to this one) executed as expected and inline with the
performance of 0.9.4. But I am still seeing some regression in other queries
but not to the extent I have noticed in this particular query.
Other option is to rewrite the query with subquery as mentioned below.. but
this requires many changes to our code..
SELECT ?url ?created ?creator ?modified ?modifier ?title ?description ?scope
?etag
WHERE
{ {Select ?url where { ?url rdf:type rm:View }}....
> 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)
