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 <[email protected]> Authored: Wed Oct 8 17:06:49 2014 +0200 Committer: Sebastian Schaffert <[email protected]> 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'
