You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@marmotta.apache.org by wi...@apache.org on 2013/04/09 08:34:32 UTC
[27/50] [abbrv] git commit: added indexes to speed up garbage
collection
added indexes to speed up garbage collection
Project: http://git-wip-us.apache.org/repos/asf/incubator-marmotta/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-marmotta/commit/69c112d3
Tree: http://git-wip-us.apache.org/repos/asf/incubator-marmotta/tree/69c112d3
Diff: http://git-wip-us.apache.org/repos/asf/incubator-marmotta/diff/69c112d3
Branch: refs/heads/develop
Commit: 69c112d32e87ecf360ce08c01020678be29a8d20
Parents: b5872e2
Author: Sebastian Schaffert <ss...@apache.org>
Authored: Mon Apr 8 17:35:13 2013 +0200
Committer: Sebastian Schaffert <ss...@apache.org>
Committed: Mon Apr 8 17:35:13 2013 +0200
----------------------------------------------------------------------
.../persistence/h2/create_versioning_tables.sql | 2 ++
.../kiwi/persistence/h2/drop_versioning_tables.sql | 2 ++
.../persistence/mysql/create_versioning_tables.sql | 2 ++
.../persistence/mysql/drop_versioning_tables.sql | 2 ++
.../persistence/pgsql/create_versioning_tables.sql | 2 ++
.../persistence/pgsql/drop_versioning_tables.sql | 2 ++
6 files changed, 12 insertions(+), 0 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-marmotta/blob/69c112d3/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/create_versioning_tables.sql
----------------------------------------------------------------------
diff --git a/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/create_versioning_tables.sql b/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/create_versioning_tables.sql
index bfb450a..9d584f0 100644
--- a/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/create_versioning_tables.sql
+++ b/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/create_versioning_tables.sql
@@ -34,7 +34,9 @@ CREATE TABLE versions_removed (
);
CREATE INDEX idx_versions_added ON versions_added(version_id);
+CREATE INDEX idx_versions_added_tid ON versions_added(triple_id);
CREATE INDEX idx_versions_removed ON versions_removed(version_id);
+CREATE INDEX idx_versions_removed_tid ON versions_removed(triple_id);
CREATE INDEX idx_versions_created ON versions(createdAt);
http://git-wip-us.apache.org/repos/asf/incubator-marmotta/blob/69c112d3/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/drop_versioning_tables.sql
----------------------------------------------------------------------
diff --git a/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/drop_versioning_tables.sql b/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/drop_versioning_tables.sql
index f86fe6a..a3416ee 100644
--- a/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/drop_versioning_tables.sql
+++ b/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/drop_versioning_tables.sql
@@ -14,6 +14,8 @@
-- limitations under the License.
DROP INDEX IF EXISTS idx_versions_added;
DROP INDEX IF EXISTS idx_versions_removed;
+DROP INDEX IF EXISTS idx_versions_added_tid;
+DROP INDEX IF EXISTS idx_versions_removed_tid;
DROP INDEX IF EXISTS idx_versions_created;
http://git-wip-us.apache.org/repos/asf/incubator-marmotta/blob/69c112d3/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/mysql/create_versioning_tables.sql
----------------------------------------------------------------------
diff --git a/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/mysql/create_versioning_tables.sql b/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/mysql/create_versioning_tables.sql
index 9792c21..80a4d82 100644
--- a/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/mysql/create_versioning_tables.sql
+++ b/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/mysql/create_versioning_tables.sql
@@ -40,6 +40,8 @@ CREATE TABLE versions_removed (
);
CREATE INDEX idx_versions_added ON versions_added(version_id);
+CREATE INDEX idx_versions_added_tid ON versions_added(triple_id);
CREATE INDEX idx_versions_removed ON versions_removed(version_id);
+CREATE INDEX idx_versions_removed_tid ON versions_removed(triple_id);
CREATE INDEX idx_versions_created ON versions(createdAt);
http://git-wip-us.apache.org/repos/asf/incubator-marmotta/blob/69c112d3/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/mysql/drop_versioning_tables.sql
----------------------------------------------------------------------
diff --git a/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/mysql/drop_versioning_tables.sql b/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/mysql/drop_versioning_tables.sql
index 4b9537e..c7b40cf 100644
--- a/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/mysql/drop_versioning_tables.sql
+++ b/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/mysql/drop_versioning_tables.sql
@@ -13,7 +13,9 @@
-- See the License for the specific language governing permissions and
-- limitations under the License.
DROP INDEX idx_versions_added on versions_added;
+DROP INDEX idx_versions_added_tid on versions_added;
DROP INDEX idx_versions_removed on versions_removed;
+DROP INDEX idx_versions_removed_tid on versions_removed;
DROP INDEX idx_versions_created on versions;
http://git-wip-us.apache.org/repos/asf/incubator-marmotta/blob/69c112d3/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/create_versioning_tables.sql
----------------------------------------------------------------------
diff --git a/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/create_versioning_tables.sql b/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/create_versioning_tables.sql
index af8a19c..69f65ec 100644
--- a/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/create_versioning_tables.sql
+++ b/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/create_versioning_tables.sql
@@ -34,6 +34,8 @@ CREATE TABLE versions_removed (
);
CREATE INDEX idx_versions_added ON versions_added(version_id);
+CREATE INDEX idx_versions_added_tid ON versions_added(triple_id);
CREATE INDEX idx_versions_removed ON versions_removed(version_id);
+CREATE INDEX idx_versions_removed_tid ON versions_removed(triple_id);
CREATE INDEX idx_versions_created ON versions(createdAt);
http://git-wip-us.apache.org/repos/asf/incubator-marmotta/blob/69c112d3/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/drop_versioning_tables.sql
----------------------------------------------------------------------
diff --git a/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/drop_versioning_tables.sql b/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/drop_versioning_tables.sql
index b6f60ec..961b906 100644
--- a/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/drop_versioning_tables.sql
+++ b/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/drop_versioning_tables.sql
@@ -14,6 +14,8 @@
-- limitations under the License.
DROP INDEX idx_versions_added;
DROP INDEX idx_versions_removed;
+DROP INDEX idx_versions_added_tid;
+DROP INDEX idx_versions_removed_tid;
DROP INDEX idx_versions_created;
DROP TABLE IF EXISTS versions_added;