diff options
| author | syuilo <Syuilotan@yahoo.co.jp> | 2021-08-15 17:13:23 +0900 |
|---|---|---|
| committer | syuilo <Syuilotan@yahoo.co.jp> | 2021-08-15 17:13:23 +0900 |
| commit | 2365761ba5445f26c8b66b3b20ef4be44e70d549 (patch) | |
| tree | ed643ec7003d3ec492ba9973264410cd6b4ffc86 /src/services/chart | |
| parent | :art: (diff) | |
| download | sharkey-2365761ba5445f26c8b66b3b20ef4be44e70d549.tar.gz sharkey-2365761ba5445f26c8b66b3b20ef4be44e70d549.tar.bz2 sharkey-2365761ba5445f26c8b66b3b20ef4be44e70d549.zip | |
perf(server): Optimize db indexes of chart tables
Diffstat (limited to 'src/services/chart')
| -rw-r--r-- | src/services/chart/core.ts | 11 |
1 files changed, 6 insertions, 5 deletions
diff --git a/src/services/chart/core.ts b/src/services/chart/core.ts index 14cbd92802..8e301e8309 100644 --- a/src/services/chart/core.ts +++ b/src/services/chart/core.ts @@ -201,11 +201,12 @@ export default abstract class Chart<T extends Record<string, any>> { ...Chart.convertSchemaToFlatColumnDefinitions(schema) }, indices: [{ - columns: ['date'] - }, { - columns: ['group'] - }, { - columns: ['date', 'group'] + columns: ['date', 'group'], + unique: true, + }, { // groupにnullが含まれると↑のuniqeuは機能しないので↓の部分インデックスでカバー + columns: ['date'], + unique: true, + where: '"group" IS NULL' }] }); } |