diff options
| author |   danielhanrahan <daniel.hanrahan@est.tech> | 2023-08-17 14:58:30 +0100 |
|---|---|---|
| committer | Daniel Hanrahan <daniel.hanrahan@est.tech> | 2024-01-10 12:44:19 +0000 |
| commit | 36b81b27703d298f016180a71c85113d5c90c6b1 (patch) | |
| tree | c2661b7f16e8366907e55ec2fd85634c12fbe51e /integration-test/src/test/resources/liquibase | |
| parent | 8e617d64a7725f5fb0f0f31a5c551ff3e1e484de (diff) | |
Enable hibernate write batching
- Implement fragment ID sequence generator with allocation size of 100
- Enable write batching for insert and update, with batch size of 100
- Write performance is over 2x faster
Issue-ID: CPS-1795
Signed-off-by: danielhanrahan <daniel.hanrahan@est.tech>
Change-Id: I7ebd0f834abb57c593603e2cd3fafc7e3425ab1e
Diffstat (limited to 'integration-test/src/test/resources/liquibase')
| -rw-r--r-- | integration-test/src/test/resources/liquibase/test-changelog.yaml | 9 |
1 files changed, 7 insertions, 2 deletions
diff --git a/integration-test/src/test/resources/liquibase/test-changelog.yaml b/integration-test/src/test/resources/liquibase/test-changelog.yaml index 3f1233145..ba639ede0 100644 --- a/integration-test/src/test/resources/liquibase/test-changelog.yaml +++ b/integration-test/src/test/resources/liquibase/test-changelog.yaml @@ -1,5 +1,5 @@ # ============LICENSE_START======================================================= -# Copyright (c) 2023 Nordix Foundation. +# Copyright (c) 2023-2024 Nordix Foundation. # ================================================================================ # Licensed under the Apache License, Version 2.0 (the "License"); # you may not use this file except in compliance with the License. @@ -100,7 +100,7 @@ databaseChangeLog: - createTable: columns: - column: - autoIncrement: true + autoIncrement: false constraints: nullable: false primaryKey: true @@ -127,6 +127,11 @@ databaseChangeLog: name: schema_node_id type: INTEGER tableName: fragment + - createSequence: + dataType: BIGINT + incrementBy: 100 + sequenceName: fragment_id_seq + startValue: 100 - changeSet: id: 1-5 author: cps |