[jira] [Resolved] (MARMOTTA-492) Issue With a SPARQL Query

["Sebastian Schaffert (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/MARMOTTA-492?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sebastian Schaffert resolved MARMOTTA-492.
------------------------------------------

    Resolution: Won't Fix

Since there is no further feedback on the issue, I assume it is fixed.

> Issue With a SPARQL Query
> -------------------------
>
>                 Key: MARMOTTA-492
>                 URL: https://issues.apache.org/jira/browse/MARMOTTA-492
>             Project: Marmotta
>          Issue Type: Improvement
>          Components: KiWi Triple Store
>    Affects Versions: 3.2.0
>            Reporter: Maxime Poitevineau-Millin 
>            Assignee: Sebastian Schaffert
>              Labels: SPARQL, optimization, postgresql
>
> We are currently implementing marmotta in our system but!
> When trying this query :
> {code}
> SELECT * FROM <sesame:nil> {
>                                ?kw rdf:type Keyword . 
>                                ?kw2 rdf:type Keyword . 
>                                ?kw2 ?rel ?kw . 
> }
> {code}
> on a database containing 60 000 keywords, marmotta is creating 60 000 * 60 000 queries similar to this one : 
> {code:sql}
> 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'
> {code}
> 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?



--
This message was sent by Atlassian JIRA
(v6.2#6252)