[MARMOTTA-492] Issue With a SPARQL Query

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 3.2.0
• Component/s: KiWi Triple Store
• Labels: SPARQL optimization postgresql
• Assignee: Sebastian Schaffert
• Reporter: Maxime Poitevineau-Millin
• Created: 23/Apr/14 12:42
• Updated: 21/Jul/14 10:43
• Resolved: 21/Jul/14 10:43

Description

We are currently implementing marmotta in our system but!

When trying this query :

SELECT * FROM <sesame:nil> {
                               ?kw rdf:type Keyword . 
                               ?kw2 rdf:type Keyword . 
                               ?kw2 ?rel ?kw . 
}

on a database containing 60 000 keywords, marmotta is creating 60 000 * 60 000 queries similar to this one :

SELECT id,subject,predicate,object,context,deleted,inferred,creator,createdAt,deletedAt FROM triples WHERE deleted = false AND subject = '458172920399523841' AND object = '458172732532453376' AND context = '458172711103754240'

Which obviously takes a long time.

This query takes 2 sec on Virtuoso or Owlim, is there any configuration issue or something we should change?

Issue Links

• is related to: MARMOTTA-493 Improve Native SPARQL Support