[jira] [Commented] (JENA-800) Query response time severily regressed when upgraded Jena TDB to 2.11.2 from 0.9.4

["Bala Kolla (JIRA)" <ji...@apache.org>]

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

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

If I disable the optimizations (by using none.opt file in TDB directory), the query response time is back to normal and matches the 0.9.4 response time.

> 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
>
> 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.
> 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)



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