diff options
| author | syuilo <syuilotan@yahoo.co.jp> | 2020-08-14 15:24:55 +0900 |
|---|---|---|
| committer | syuilo <syuilotan@yahoo.co.jp> | 2020-08-14 15:24:55 +0900 |
| commit | 7c5ac2cbb407fbcdd06f7561ccbcff56c9da6a14 (patch) | |
| tree | d617bbb0e70a5c627a10b31f5e7bc940b6bde046 | |
| parent | GCSに大きいファイルがアップロードできないのを修正 Fix ... (diff) | |
| download | misskey-7c5ac2cbb407fbcdd06f7561ccbcff56c9da6a14.tar.gz misskey-7c5ac2cbb407fbcdd06f7561ccbcff56c9da6a14.tar.bz2 misskey-7c5ac2cbb407fbcdd06f7561ccbcff56c9da6a14.zip | |
perf(server): Add isSensitive index to improve query performance
| -rw-r--r-- | migration/1597385880794-add-sensitive-index.ts | 14 | ||||
| -rw-r--r-- | src/models/entities/drive-file.ts | 1 |
2 files changed, 15 insertions, 0 deletions
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<void> { + await queryRunner.query(`CREATE INDEX "IDX_a7eba67f8b3fa27271e85d2e26" ON "drive_file" ("isSensitive") `); + } + + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`DROP INDEX "IDX_a7eba67f8b3fa27271e85d2e26"`); + } + +} diff --git a/src/models/entities/drive-file.ts b/src/models/entities/drive-file.ts index c02b9f3636..680a40bc06 100644 --- a/src/models/entities/drive-file.ts +++ b/src/models/entities/drive-file.ts @@ -145,6 +145,7 @@ export class DriveFile { @JoinColumn() public folder: DriveFolder | null; + @Index() @Column('boolean', { default: false, comment: 'Whether the DriveFile is NSFW.' |