You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@marmotta.apache.org by ss...@apache.org on 2014/10/08 17:06:25 UTC
git commit: simple performance improvement for context size
Repository: marmotta
Updated Branches:
refs/heads/develop 22a52b32d -> 57b0dfb55
simple performance improvement for context size
Project: http://git-wip-us.apache.org/repos/asf/marmotta/repo
Commit: http://git-wip-us.apache.org/repos/asf/marmotta/commit/57b0dfb5
Tree: http://git-wip-us.apache.org/repos/asf/marmotta/tree/57b0dfb5
Diff: http://git-wip-us.apache.org/repos/asf/marmotta/diff/57b0dfb5
Branch: refs/heads/develop
Commit: 57b0dfb553429274649a36fb1ddef13cf678974e
Parents: 22a52b3
Author: Sebastian Schaffert <ss...@apache.org>
Authored: Wed Oct 8 17:06:49 2014 +0200
Committer: Sebastian Schaffert <ss...@apache.org>
Committed: Wed Oct 8 17:06:49 2014 +0200
----------------------------------------------------------------------
.../apache/marmotta/kiwi/persistence/h2/statements.properties | 4 ++--
.../apache/marmotta/kiwi/persistence/mysql/statements.properties | 4 ++--
.../apache/marmotta/kiwi/persistence/pgsql/statements.properties | 4 ++--
3 files changed, 6 insertions(+), 6 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/marmotta/blob/57b0dfb5/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/statements.properties
----------------------------------------------------------------------
diff --git a/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/statements.properties b/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/statements.properties
index 08b996a..8e1a747 100644
--- a/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/statements.properties
+++ b/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/statements.properties
@@ -65,8 +65,8 @@ store.triple = MERGE INTO triples (id,subject,predicate,object,context,i
load.triple = SELECT id FROM triples WHERE subject = ? AND predicate = ? AND object = ? AND context = ? AND deleted = false
-query.size = SELECT count(*) FROM triples WHERE deleted = false AND inferred = false
-query.size_ctx = SELECT count(*) FROM triples WHERE context = ? AND deleted = false AND inferred = false
+query.size = SELECT count(*) FROM triples WHERE deleted = false
+query.size_ctx = SELECT count(*) FROM triples WHERE context = ? AND deleted = false
query.contexts = SELECT DISTINCT context FROM triples WHERE deleted = false
query.namespaces = SELECT id,prefix,uri,createdAt FROM namespaces
query.resources = SELECT id,ntype,svalue,createdAt FROM nodes WHERE ntype = 'uri' OR ntype = 'bnode'
http://git-wip-us.apache.org/repos/asf/marmotta/blob/57b0dfb5/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/mysql/statements.properties
----------------------------------------------------------------------
diff --git a/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/mysql/statements.properties b/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/mysql/statements.properties
index 9ccaee0..0963ab5 100644
--- a/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/mysql/statements.properties
+++ b/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/mysql/statements.properties
@@ -63,8 +63,8 @@ store.triple = INSERT IGNORE INTO triples (id,subject,predicate,object,c
load.triple = SELECT id FROM triples WHERE subject = ? AND predicate = ? AND object = ? AND context = ? AND deleted = false
-query.size = SELECT count(*) FROM triples WHERE deleted = false AND inferred = false
-query.size_ctx = SELECT count(*) FROM triples WHERE context = ? AND deleted = false AND inferred = false
+query.size = SELECT count(*) FROM triples WHERE deleted = false
+query.size_ctx = SELECT count(*) FROM triples WHERE context = ? AND deleted = false
query.contexts = SELECT DISTINCT context FROM triples WHERE deleted = false
query.namespaces = SELECT id,prefix,uri,createdAt FROM namespaces
query.resources = SELECT id,ntype,svalue,createdAt FROM nodes WHERE ntype = 'uri' OR ntype = 'bnode'
http://git-wip-us.apache.org/repos/asf/marmotta/blob/57b0dfb5/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/statements.properties
----------------------------------------------------------------------
diff --git a/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/statements.properties b/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/statements.properties
index 31de1f0..7ed1e51 100644
--- a/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/statements.properties
+++ b/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/statements.properties
@@ -60,8 +60,8 @@ store.namespace = INSERT INTO namespaces (id,prefix,uri,createdAt) VALUES (
store.triple = INSERT INTO triples (id,subject,predicate,object,context,inferred,createdAt) VALUES (?,?,?,?,?,?,?)
load.triple = SELECT id FROM triples WHERE subject = ? AND predicate = ? AND object = ? AND context = ? AND deleted = false
-query.size = SELECT count(*) FROM triples WHERE deleted = false AND inferred = false
-query.size_ctx = SELECT count(*) FROM triples WHERE context = ? AND deleted = false AND inferred = false
+query.size = SELECT count(*) FROM triples WHERE deleted = false
+query.size_ctx = SELECT count(*) FROM triples WHERE context = ? AND deleted = false
query.contexts = SELECT DISTINCT context FROM triples WHERE deleted = false
query.namespaces = SELECT id,prefix,uri,createdAt FROM namespaces
query.resources = SELECT id,ntype,svalue,createdAt FROM nodes WHERE ntype = 'uri' OR ntype = 'bnode'