diff options
| author | lijinyang <[email protected]> | 2023-09-27 09:46:45 +0800 |
|---|---|---|
| committer | lijinyang <[email protected]> | 2023-09-27 09:46:45 +0800 |
| commit | 36f8a2ec6830d7ae7deee4ce10eaf15ebd960050 (patch) | |
| tree | ccf8fc0a0272fda998f0d0a5f82db24f5370e6c8 | |
| parent | e71a73f162f5887b1a3858e1ae8f1ef6900ae62b (diff) | |
fix:CN-1358 实体标签查询耗时优化
| -rw-r--r-- | cn-admin/src/main/resources/db/V23.09.26__modify ioc_darkweb_index.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/cn-admin/src/main/resources/db/V23.09.26__modify ioc_darkweb_index.sql b/cn-admin/src/main/resources/db/V23.09.26__modify ioc_darkweb_index.sql new file mode 100644 index 0000000..62cd953 --- /dev/null +++ b/cn-admin/src/main/resources/db/V23.09.26__modify ioc_darkweb_index.sql @@ -0,0 +1,5 @@ +ALTER TABLE `cn_ioc_darkweb` + ADD INDEX `type_value`(`ioc_type`(255), `ioc_value`(255)) USING BTREE; + +ALTER TABLE `cn_ioc_malware` + ADD INDEX `type_value`(`ioc_type`(255), `ioc_value`(512)) USING BTREE;
\ No newline at end of file |