bbs
/
clrghouz
1
0
Fork 0
Code Issues 1 Pull Requests Actions Packages Projects 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
master
bbs
dev
test
Labels
Clear labels
No items
No Label
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(<nil>)"

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?