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

Reply via email to