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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Done
• Affects Version/s: Jena 2.11.2
• Fix Version/s: Jena 2.13.0
• Component/s: ARQ, TDB
• Assignee: Andy Seaborne
• Reporter: Bala Kolla
• Created: 17/Oct/14 13:34
• Updated: 05/Nov/14 12:27
• Resolved: 05/Nov/14 10:04

Description

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)

Issue Links

• relates to: JENA-685 Improve fixed algorithm BGP weighting.