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 <[email protected]> Authored: Sun May 26 14:49:04 2013 +0200 Committer: Sebastian Schaffert <[email protected]> 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;
