From 7c5ac2cbb407fbcdd06f7561ccbcff56c9da6a14 Mon Sep 17 00:00:00 2001 From: syuilo Date: Fri, 14 Aug 2020 15:24:55 +0900 Subject: perf(server): Add isSensitive index to improve query performance --- migration/1597385880794-add-sensitive-index.ts | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 migration/1597385880794-add-sensitive-index.ts (limited to 'migration') diff --git a/migration/1597385880794-add-sensitive-index.ts b/migration/1597385880794-add-sensitive-index.ts new file mode 100644 index 0000000000..ff6251ac0a --- /dev/null +++ b/migration/1597385880794-add-sensitive-index.ts @@ -0,0 +1,14 @@ +import {MigrationInterface, QueryRunner} from "typeorm"; + +export class addSensitiveIndex1597385880794 implements MigrationInterface { + name = 'addSensitiveIndex1597385880794' + + public async up(queryRunner: QueryRunner): Promise { + await queryRunner.query(`CREATE INDEX "IDX_a7eba67f8b3fa27271e85d2e26" ON "drive_file" ("isSensitive") `); + } + + public async down(queryRunner: QueryRunner): Promise { + await queryRunner.query(`DROP INDEX "IDX_a7eba67f8b3fa27271e85d2e26"`); + } + +} -- cgit v1.2.3-freya