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 2013/05/26 14:49:20 UTC
git commit: further improved the indexes a bit
Updated Branches:
refs/heads/develop 93e1f2eda -> 58cb4f57b
further improved the indexes a bit
Project: http://git-wip-us.apache.org/repos/asf/incubator-marmotta/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-marmotta/commit/58cb4f57
Tree: http://git-wip-us.apache.org/repos/asf/incubator-marmotta/tree/58cb4f57
Diff: http://git-wip-us.apache.org/repos/asf/incubator-marmotta/diff/58cb4f57
Branch: refs/heads/develop
Commit: 58cb4f57b1a53785764e3ce426cec09695a9c5d3
Parents: 93e1f2e
Author: Sebastian Schaffert <ss...@apache.org>
Authored: Sun May 26 14:49:04 2013 +0200
Committer: Sebastian Schaffert <ss...@apache.org>
Committed: Sun May 26 14:49:04 2013 +0200
----------------------------------------------------------------------
.../kiwi/persistence/h2/create_base_tables.sql | 7 +------
.../kiwi/persistence/h2/drop_base_tables.sql | 7 +------
.../kiwi/persistence/mysql/create_base_tables.sql | 7 +------
.../kiwi/persistence/mysql/drop_base_tables.sql | 7 +------
.../kiwi/persistence/pgsql/create_base_tables.sql | 8 ++------
.../kiwi/persistence/pgsql/drop_base_tables.sql | 7 +------
6 files changed, 7 insertions(+), 36 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-marmotta/blob/58cb4f57/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/create_base_tables.sql
----------------------------------------------------------------------
diff --git a/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/create_base_tables.sql b/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/create_base_tables.sql
index 89bb625..f6e1722 100644
--- a/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/create_base_tables.sql
+++ b/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/create_base_tables.sql
@@ -66,13 +66,8 @@ CREATE TABLE metadata (
CREATE INDEX idx_node_content ON nodes(svalue);
CREATE INDEX idx_literal_lang ON nodes(lang);
--- CREATE INDEX idx_triples_s ON triples(subject);
-CREATE INDEX idx_triples_o ON triples(object);
--- CREATE INDEX idx_triples_sp ON triples(subject,predicate);
-CREATE INDEX idx_triples_po ON triples(predicate,object);
CREATE INDEX idx_triples_spo ON triples(subject,predicate,object);
--- CREATE INDEX idx_triples_cs ON triples(context,subject);
--- CREATE INDEX idx_triples_csp ON triples(context,subject,predicate);
+CREATE INDEX idx_triples_op ON triples(object,predicate);
CREATE INDEX idx_triples_cspo ON triples(context,subject,predicate,object);
CREATE INDEX idx_namespaces_uri ON namespaces(uri);
http://git-wip-us.apache.org/repos/asf/incubator-marmotta/blob/58cb4f57/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/drop_base_tables.sql
----------------------------------------------------------------------
diff --git a/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/drop_base_tables.sql b/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/drop_base_tables.sql
index 7361db3..41ca5f7 100644
--- a/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/drop_base_tables.sql
+++ b/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/drop_base_tables.sql
@@ -16,13 +16,8 @@
DROP INDEX IF EXISTS idx_node_content;
DROP INDEX IF EXISTS idx_literal_lang;
--- DROP INDEX IF EXISTS idx_triples_s;
-DROP INDEX IF EXISTS idx_triples_o;
--- DROP INDEX IF EXISTS idx_triples_sp;
-DROP INDEX IF EXISTS idx_triples_po;
+DROP INDEX IF EXISTS idx_triples_op;
DROP INDEX IF EXISTS idx_triples_spo;
--- DROP INDEX IF EXISTS idx_triples_cs;
--- DROP INDEX IF EXISTS idx_triples_csp;
DROP INDEX IF EXISTS idx_triples_cspo;
DROP INDEX IF EXISTS idx_namespaces_uri;
http://git-wip-us.apache.org/repos/asf/incubator-marmotta/blob/58cb4f57/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/mysql/create_base_tables.sql
----------------------------------------------------------------------
diff --git a/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/mysql/create_base_tables.sql b/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/mysql/create_base_tables.sql
index 1910e48..d2db972 100644
--- a/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/mysql/create_base_tables.sql
+++ b/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/mysql/create_base_tables.sql
@@ -75,13 +75,8 @@ CREATE TABLE metadata (
CREATE INDEX idx_node_content ON nodes(svalue(256));
CREATE INDEX idx_literal_lang ON nodes(lang);
--- CREATE INDEX idx_triples_s ON triples(subject);
-CREATE INDEX idx_triples_o ON triples(object);
--- CREATE INDEX idx_triples_sp ON triples(subject,predicate);
-CREATE INDEX idx_triples_po ON triples(predicate,object);
+CREATE INDEX idx_triples_op ON triples(object,predicate);
CREATE INDEX idx_triples_spo ON triples(subject,predicate,object);
--- CREATE INDEX idx_triples_cs ON triples(context,subject);
--- CREATE INDEX idx_triples_csp ON triples(context,subject,predicate);
CREATE INDEX idx_triples_cspo ON triples(context,subject,predicate,object);
CREATE INDEX idx_namespaces_uri ON namespaces(uri);
http://git-wip-us.apache.org/repos/asf/incubator-marmotta/blob/58cb4f57/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/mysql/drop_base_tables.sql
----------------------------------------------------------------------
diff --git a/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/mysql/drop_base_tables.sql b/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/mysql/drop_base_tables.sql
index 3291a73..5a91f23 100644
--- a/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/mysql/drop_base_tables.sql
+++ b/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/mysql/drop_base_tables.sql
@@ -16,13 +16,8 @@
DROP INDEX idx_node_content ON nodes;
DROP INDEX idx_literal_lang ON nodes;
--- DROP INDEX idx_triples_s ON triples;
-DROP INDEX idx_triples_o ON triples;
--- DROP INDEX idx_triples_sp ON triples;
-DROP INDEX idx_triples_po ON triples;
+DROP INDEX idx_triples_op ON triples;
DROP INDEX idx_triples_spo ON triples;
--- DROP INDEX idx_triples_cs ON triples;
--- DROP INDEX idx_triples_csp ON triples;
DROP INDEX idx_triples_cspo ON triples;
DROP INDEX idx_namespaces_uri ON namespaces;
http://git-wip-us.apache.org/repos/asf/incubator-marmotta/blob/58cb4f57/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/create_base_tables.sql
----------------------------------------------------------------------
diff --git a/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/create_base_tables.sql b/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/create_base_tables.sql
index f51510b..f748add 100644
--- a/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/create_base_tables.sql
+++ b/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/create_base_tables.sql
@@ -67,15 +67,11 @@ CREATE TABLE metadata (
CREATE INDEX idx_node_content ON nodes USING hash(svalue);
CREATE INDEX idx_literal_lang ON nodes(lang) WHERE ntype = 'string';
---CREATE INDEX idx_triples_s ON triples(subject) WHERE deleted = false;
-CREATE INDEX idx_triples_o ON triples(object) WHERE deleted = false;
---CREATE INDEX idx_triples_sp ON triples(subject,predicate) WHERE deleted = false;
-CREATE INDEX idx_triples_po ON triples(predicate,object) WHERE deleted = false;
+CREATE INDEX idx_triples_op ON triples(object,predicate) WHERE deleted = false;
CREATE INDEX idx_triples_spo ON triples(subject,predicate,object) WHERE deleted = false;
---CREATE INDEX idx_triples_cs ON triples(context,subject) WHERE deleted = false;
---CREATE INDEX idx_triples_csp ON triples(context,subject,predicate) WHERE deleted = false;
CREATE INDEX idx_triples_cspo ON triples(context,subject,predicate,object) WHERE deleted = false;
+
CREATE INDEX idx_namespaces_uri ON namespaces(uri);
CREATE INDEX idx_namespaces_prefix ON namespaces(prefix);
http://git-wip-us.apache.org/repos/asf/incubator-marmotta/blob/58cb4f57/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/drop_base_tables.sql
----------------------------------------------------------------------
diff --git a/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/drop_base_tables.sql b/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/drop_base_tables.sql
index e978660..5a34920 100644
--- a/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/drop_base_tables.sql
+++ b/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/drop_base_tables.sql
@@ -15,13 +15,8 @@
DROP INDEX idx_node_content;
DROP INDEX idx_literal_lang;
--- DROP INDEX idx_triples_s;
-DROP INDEX idx_triples_o;
--- DROP INDEX idx_triples_sp;
-DROP INDEX idx_triples_po;
+DROP INDEX idx_triples_op;
DROP INDEX idx_triples_spo;
--- DROP INDEX idx_triples_cs;
--- DROP INDEX idx_triples_csp;
DROP INDEX idx_triples_cspo;
DROP INDEX idx_namespaces_uri;