-
[OPIK-3990] [BE] Optimize DatasetVersionDAO queries and add composite index (#4882)
frostbyte_neo 发布于
2026-01-23 15:08:58 +00:00 -
[OPIK-3990] [BE] Add missing index to dataset versions
-
[OPIK-3990] [BE] Reduce query cost for dataset version table
-
[OPIK-3990] [BE] Add missing index to dataset versions
-
Update apps/opik-backend/src/main/resources/liquibase/db-app-state/migrations/000047_add_missing_index_to_dataset_versions.sql
Co-authored-by: baz-reviewer[bot] <174234987+baz-reviewer[bot]@users.noreply.github.com>
- [OPIK-3990] [BE] Optimize DatasetVersionDAO queries and add composite index
- Optimize findById: Filter version_sequences CTE by dataset_id and filter tag aggregation by version_id
- Optimize findByIds: Filter version_sequences by target datasets and filter tag aggregation by version_ids
- Optimize findLatestVersionsByDatasetIds: Move tag filter into subquery and remove JSON_CONTAINS
- Optimize findByBatchGroupId, findByHash, findByDatasetId, findByTag: Filter tag aggregation by version_sequences
- Add composite index idx_dataset_version_tags_tag_version on (tag, version_id) for tag-filtered queries
- Combine migrations 000048 and 000049 into single migration (version_id index already exists from FK)
Co-authored-by: baz-reviewer[bot] <174234987+baz-reviewer[bot]@users.noreply.github.com>
下载附件
-