Updated Branches: refs/heads/master 7b7869edf -> 0825b6828
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/master Commit: 69c112d32e87ecf360ce08c01020678be29a8d20 Parents: b5872e2 Author: Sebastian Schaffert <[email protected]> Authored: Mon Apr 8 17:35:13 2013 +0200 Committer: Sebastian Schaffert <[email protected]> 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;
