bbs/clrghouz
1
0
Fork 0
Code Issues 5 Pull Requests Actions Packages Projects 1 Releases Wiki Activity

DB Query Optimisation needed on receipt of new mail #5

New Issue
Closed
opened 2022-03-25 23:45:05 +00:00 by deon · 0 comments
deon commented 2022-03-25 23:45:05 +00:00 (Migrated from gitlab.dege.au)
Copy Link

It is currently taking too long to process each incoming echomail (and possibly netmail) message. So if we are not queuing mail up for later processing, the binkp session can "timeout" before a packet is processed.

Some optimisations are needed to reduce the time it processes each message - so things that might need to be reviewed:

  • SQL queries run during processing of each message - are they all required?
  • Can some write queries be deferred - eg: SEENBY/PATH?
It is currently taking too long to process each incoming echomail (and possibly netmail) message. So if we are not queuing mail up for later processing, the binkp session can "timeout" before a packet is processed. Some optimisations are needed to reduce the time it processes each message - so things that might need to be reviewed: * SQL queries run during processing of each message - are they all required? * Can some write queries be deferred - eg: SEENBY/PATH?
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels   
bug

Something is not working

  
duplicate

This issue or pull request already exists

  
enhancement

New feature

  
help wanted

Need some help

  
invalid

Something is wrong

  
question

More information is needed

  
wontfix

This won't be fixed

No Label
bug
duplicate
enhancement
help wanted
invalid
question
wontfix
Milestone
Clear milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: bbs/clrghouz#5
No description provided.
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?