Skip to content

通过队列化索引历史数据以提升数据库稳定性 #7386

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Closed
88250 opened this issue Feb 16, 2023 · 7 comments
Closed

通过队列化索引历史数据以提升数据库稳定性 #7386

88250 opened this issue Feb 16, 2023 · 7 comments
Assignees
@88250
Labels
Enhancement
Milestone
2.7.6

Comments

@88250
Copy link
Member

88250 commented Feb 16, 2023

https://ld246.com/article/1676521024001

避免数据库报被锁定的错误。
@88250 88250 added this to the 2.7.6 milestone Feb 16, 2023
@88250 88250 self-assigned this Feb 16, 2023
88250 added a commit to siyuan-note/eventbus that referenced this issue Feb 16, 2023
@88250
🎨 历史数据库索引队列化 siyuan-note/siyuan#7386
15f8e2f
88250 added a commit to siyuan-note/eventbus that referenced this issue Feb 16, 2023
@88250
🎨 历史数据库索引队列化 siyuan-note/siyuan#7386
41885ea
88250 added a commit that referenced this issue Feb 16, 2023
@88250
🎨 历史数据库索引队列化 #7386
f581b34
@88250 88250 changed the title 历史数据库索引队列化 历史数据库索引队列化以提升数据库稳定性 Feb 16, 2023
@88250 88250 changed the title 历史数据库索引队列化以提升数据库稳定性 通过队列化索引历史数据来提升数据库稳定性 Feb 16, 2023
@88250 88250 changed the title 通过队列化索引历史数据来提升数据库稳定性 通过队列化索引历史数据以提升数据库稳定性 Feb 16, 2023
@88250 88250 closed this as completed Feb 16, 2023
@Temacc0531
Copy link

v2.7.6-dev1 发现一个问题，重复点历史数据的重建索引会一会左边有更改记录，一会更改记录全消失

@88250
Copy link
Member Author

88250 commented Feb 17, 2023

重建索引是会删除后重建。

88250 added a commit that referenced this issue Feb 17, 2023
@88250
🎨 历史数据库索引队列化 #7386
c61e0ef
@Temacc0531
Copy link

我录了个屏，每次重建索引出来的结果都是不一样的

GIF 23-2-17 14-57-57

@88250
Copy link
Member Author

88250 commented Feb 17, 2023

得等这里跑完再点下一次。

image

@Temacc0531
Copy link

那那个遮罩是不是要等执行完再消失😂，不然用户会觉得程序已经处理好了，而且左下角的历史数据条数好像每次也还都不一样

@88250
Copy link
Member Author

88250 commented Feb 17, 2023

嗯，等后面考虑改下看看。

88250 added a commit that referenced this issue Feb 17, 2023
@88250
🎨 重建历史索引遮罩 #7386
9b4a6eb
88250 added a commit that referenced this issue Feb 17, 2023
@88250
🎨 重建历史索引遮罩 #7386
fa1ee8f
88250 added a commit that referenced this issue Feb 17, 2023
@88250
🎨 重建历史索引遮罩 #7386
d5999b2
88250 added a commit that referenced this issue Feb 17, 2023
@88250
🎨 重建历史索引遮罩 #7386
ae47483
@88250
Copy link
Member Author

88250 commented Feb 17, 2023

取消遮罩了，界面右上角弹重建历史数据索引提示，重建进度在状态栏显示。

88250 added a commit that referenced this issue Feb 17, 2023
@88250
🎨 重建历史索引遮罩 #7386
e1375fd
88250 added a commit that referenced this issue Feb 17, 2023
@88250
🎨 重建历史索引遮罩 #7386
aa47da6
88250 added a commit that referenced this issue Feb 17, 2023
@88250
🎨 重建历史索引遮罩 #7386
3cd634d
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@88250 88250

Labels
Enhancement
Projects
None yet
Milestone
2.7.6
Development

No branches or pull requests
2 participants
@88250 @Temacc0531