[
https://issues.apache.org/jira/browse/JENA-800?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14179906#comment-14179906
]
Andy Seaborne commented on JENA-800:
------------------------------------
The fixed optimizer is now a two level set of decisions.
Bala - your data profile is unusual (unless {{jfs:resourceContext
<https://rmserverurl/projects/projectUUID>}} is basically a no-op and does not
change the query).
A starting approximation of the old fixed optimizer is:
{noformat}
(stats
((TERM TERM VAR) 2)
((TERM rdf:type VAR) 5)
((VAR TERM TERM) 3)
((TERM TERM TERM) 2)
((TERM VAR VAR) 10)
((VAR VAR TERM) 20)
((VAR TERM VAR) 30)
((VAR VAR VAR) 100)
)
{noformat}
Exact numbers don't matter - it's the relative ordering of choices that
matters. It would be good to know the collected stats as Rob describes as just
because this case is adjusted, other cases of rdf:type/some property choices
are also affected.
> 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)
