You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@marmotta.apache.org by "Maxime Poitevineau-Millin (JIRA)" <ji...@apache.org> on 2014/04/23 16:15:17 UTC
[jira] [Comment Edited] (MARMOTTA-492) Issue With a SPARQL Query
[ https://issues.apache.org/jira/browse/MARMOTTA-492?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13978226#comment-13978226 ]
Maxime Poitevineau-Millin edited comment on MARMOTTA-492 at 4/23/14 2:14 PM:
------------------------------------------------------------------------------
Hi,
Sorry for the missing (code) in the first message
We are using postgres and the Kiwi system
How we use (test) Marmotta -
Part of our code without the try,method... :
{code}
String defaultContext = "http://localhost/context/default";
String inferredContext = "http://localhost/context/inferred";
KiWiDialect dialect = new PostgreSQLDialect();
KiWiConfiguration conf = new KiWiConfiguration("xxxx", "jdbc:postgresql://192.168.xxx.xxx:5432/xxxx", "xxx", "xxxxxxxx", dialect, defaultContext, inferredContext);
conf.setCachingBackend(CachingBackends.INFINISPAN_CLUSTERED);
KiWiStore store = new KiWiStore(conf);
Repository repository = new SailRepository(store).initialize();
TupleQueryResult lignes = repository.getConnection().prepareTupleQuery( QueryLanguage.SPARQL, req ).evaluate();
{code}
was (Author: p1001):
Hi,
Sorry for the missing
We are using postgres and the Kiwi system
How we use (test) Marmotta -
Part of our code without the try,method... :
{code}
String defaultContext = "http://localhost/context/default";
String inferredContext = "http://localhost/context/inferred";
KiWiDialect dialect = new PostgreSQLDialect();
KiWiConfiguration conf = new KiWiConfiguration("xxxx", "jdbc:postgresql://192.168.xxx.xxx:5432/xxxx", "xxx", "xxxxxxxx", dialect, defaultContext, inferredContext);
conf.setCachingBackend(CachingBackends.INFINISPAN_CLUSTERED);
KiWiStore store = new KiWiStore(conf);
Repository repository = new SailRepository(store).initialize();
TupleQueryResult lignes = repository.getConnection().prepareTupleQuery( QueryLanguage.SPARQL, req ).evaluate();
{code}
> 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)