temp-tickets/tickets
10
0
Code Issues 453 Packages Projects 4 Wiki

内镜追溯系统 数据库视图批量优化（提速第一步 ect_cycles 转视图，最小代码改动） #316

New Issue
Open
opened 2025-12-31 11:06:12 +08:00 by bigtran · 2 comments
bigtran commented 2025-12-31 11:06:12 +08:00
Owner
Copy Link
Copy Source

v_clean sql 查询速度 3.5s -> 0.33s，页面接口返回速度 15.63s ->5.53s （性能瓶颈不在sql本身，在页面内部）

优化前

image.png
image.png

优化后

image.png
image.png

# v_clean sql 查询速度 3.5s -> 0.33s，页面接口返回速度 15.63s ->5.53s （性能瓶颈不在sql本身，在页面内部） ## 优化前 ![image.png](/attachments/e61e03f9-f393-40ab-a262-aca33ee2cf9f) ![image.png](/attachments/ed450186-031e-467a-9e0e-13982b62bcf5) ## 优化后 ![image.png](/attachments/c0a67319-843e-4f9b-ab3e-afc9cf9fd62f) ![image.png](/attachments/a23f84c8-58fe-419c-8fbe-f948cebbad82)
image.png
75 KiB
image.png
36 KiB
image.png
174 KiB
image.png
34 KiB
image.png
89 KiB
image.png
87 KiB
image.png image.png
bigtran commented 2025-12-31 11:46:47 +08:00
Author
Owner
Copy Link
Copy Source

v_check 0.821s -> 0.368s

image.png

image.png

# v_check 0.821s -> 0.368s ![image.png](/attachments/d6ac1343-8c86-45ee-bcd4-63cfb3ec6401) ![image.png](/attachments/455ab7be-9489-4d85-8fc1-c97440aa30b4)
image.png
80 KiB
image.png
79 KiB
bigtran commented 2026-01-03 15:52:02 +08:00
Author
Owner
Copy Link
Copy Source

v_report_clean_check_leaktest 5.8s -> 0.157

优化前

image.png

优化后

image.png

image.png

两个sql的结果不同，初步认为以前的有毛病，进一步再验证一下。

# v_report_clean_check_leaktest 5.8s -> 0.157 ## 优化前 ![image.png](/attachments/1394d2d9-ae95-4e76-876a-ccb3eae6172e) ## 优化后 ![image.png](/attachments/b3e4fe23-f043-4c66-8cc3-fb8b8f7e38eb) ![image.png](/attachments/ee19e948-99b7-4416-864c-02aa54dad5aa) # 两个sql的结果不同，初步认为以前的有毛病，进一步再验证一下。
image.png
158 KiB
image.png
72 KiB
image.png
384 KiB
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
1-feature
2-bug
Something is not working
 3-enhancement
New feature
 4-document
5-bloody-version-diff
搞死人的版本差异
 6-now-commit-to-fix
下定决心解决，用行动证明，用结果证明
 duplicate
This issue or pull request already exists
 invalid
Something is wrong
 wontfix
This won't be fixed
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
bigtran (张大川) chenyingjie fanjc huangyanxue liuning panzs qilisong yanyanyan
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: temp-tickets/tickets#316
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?