[
https://issues.apache.org/jira/browse/MARMOTTA-492?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jakob Frank updated MARMOTTA-492:
---------------------------------
Description:
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?
was:
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 With a SPARQL Query
> -------------------------
>
> Key: MARMOTTA-492
> URL: https://issues.apache.org/jira/browse/MARMOTTA-492
> Project: Marmotta
> Issue Type: Bug
> Components: Sesame Tools
> Affects Versions: 3.2.0
> Reporter: Maxime Poitevineau-Millin
> Labels: SPARQL
>
> 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)
