Skip to content
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

5.7.B5414 update hm_messages set messageflags #221

Closed
mns17 opened this issue Mar 26, 2017 · 1 comment
Closed

5.7.B5414 update hm_messages set messageflags #221

mns17 opened this issue Mar 26, 2017 · 1 comment
Milestone
5.7

Comments

@mns17
Copy link

mns17 commented Mar 26, 2017

change from:
String sql = "update hm_messages set messageflags = messageflags & ~ @flags where messageaccountid = @accountid and messagefolderid = @FOLDERID;
to:
String sql = "update hm_messages set messageflags = messageflags & ~ @flags where messageaccountid = @accountid and messagefolderid = @FOLDERID and NOT messageflags = messageflags & ~ @flags";

This patch will speed up the request
@mns17 mns17 changed the title update hm_messages set messageflags 5.7.B5414 update hm_messages set messageflags Mar 26, 2017
RvdHout added a commit to RvdHout/hmailserver that referenced this issue Aug 6, 2017
@RvdHout
- Sub OnHELO(oClient) hmailserver#153 hmailserver#153
817ca42 
- Fixed Incorrect DEBUG logging for event 'OnDeliverMessage' hmailserver#181 hmailserver#181
- Include HTMLBody into IMAP TEXT search hmailserver#193
- Fixed implicit conversion: "int" to "unsigned char" hmailserver#204
- Faulty: SMTP 'Disconnect client after too many invalid commands' hmailserver#160 hmailserver#160
- SMTP server error "550 Unsupported ESMTP extension" on MAIL FROM:... AUTH=<> [with fix] hmailserver#164 hmailserver#164
- Remove 15GB backup limit hmailserver#69 hmailserver#69
- Speed up 'update hm_messages set messageflags' hmailserver#221 hmailserver#221
- https://www.hmailserver.com/forum/viewtopic.php?f=7&p=196733#p196733 (Ofice 2016 Read-Receipt Bug)
- Add Return-Path as topmost header before sending the message to SA (+ delete Return-Path header after the SA check completes) hmailserver#116
@martinknafve martinknafve added this to the 5.7 milestone Aug 17, 2019
@martinknafve
Copy link
Collaborator

This may be a performance improvement for some database, but the syntax is not compatible with SQL Server Compact so can't include the change.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
5.7
Development

No branches or pull requests
2 participants
@martinknafve @mns17