From 73caf5a7072976021f43a764ed2ad73404f4d040 Mon Sep 17 00:00:00 2001
From: fuliqi <fuliqi@qq.com>
Date: 星期四, 02 一月 2025 13:42:15 +0800
Subject: [PATCH] mongo索引、运行监控报表调整
---
ycl-pojo/src/main/java/com/ycl/platform/domain/result/UY/RecordMetaDSumResult.java | 13 +++++++++----
1 files changed, 9 insertions(+), 4 deletions(-)
diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/result/UY/RecordMetaDSumResult.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/result/UY/RecordMetaDSumResult.java
index a07c5c9..f005ce1 100644
--- a/ycl-pojo/src/main/java/com/ycl/platform/domain/result/UY/RecordMetaDSumResult.java
+++ b/ycl-pojo/src/main/java/com/ycl/platform/domain/result/UY/RecordMetaDSumResult.java
@@ -3,6 +3,9 @@
import com.fasterxml.jackson.annotation.JsonFormat;
import com.ycl.platform.domain.result.BaseResult;
import lombok.Data;
+import org.springframework.data.mongodb.core.index.CompoundIndex;
+import org.springframework.data.mongodb.core.index.CompoundIndexes;
+import org.springframework.data.mongodb.core.index.Indexed;
import org.springframework.data.mongodb.core.index.TextIndexed;
import org.springframework.data.mongodb.core.mapping.Document;
@@ -16,12 +19,16 @@
*/
@Data
@Document(collection = "uy_record_meta_d_sum")
+@CompoundIndexes({
+ //name锛氱储寮曞悕绉� def锛氬瓧娈�(1姝ｅ簭 -1鍊掑簭) unique锛氭槸鍚﹀敮涓�绱㈠紩
+ //鐩存帴鍔犲埌瀛楁涓婇潰娌＄敤
+ @CompoundIndex(name = "video_record", def = "{statTime:-1, no:1}")
+})
public class RecordMetaDSumResult extends BaseResult {
/**
* 琛屾斂鍖哄煙鍚嶇О
*/
- @TextIndexed
private String arealayername;
/**
@@ -38,13 +45,11 @@
/**
* 鎽勫儚鏈篒D
*/
- @TextIndexed
private String deviceId;
/**
* 鎽勫儚鏈哄悕绉�
*/
- @TextIndexed
private String deviceName;
/**
@@ -60,7 +65,6 @@
/**
* 鍥芥爣骞冲彴ID
*/
- @TextIndexed
private String platId;
/**
@@ -82,6 +86,7 @@
* 缁熻鏃堕棿锛屾牸寮忎负鏃ユ湡瀛楃涓�
*/
@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ @Indexed(background = true)
private Date statTime;
/**
--
Gitblit v1.8.0