bcgov / bcgov/SIMS

Create index for sims.notifications table with dateSent and createdAt

Open
#1,618 1 comment 0 reactions 0 assignees View on GitHub
Technical Debt
Dominant language
TypeScript
Stars
29
Forks
15
PR merge metrics
No merged PRs in 30d

Description

**Describe the task**
Create index for sims.notifications table with dateSent and createdAt as sims.notifications can grow in large numbers and will be retrieved every minute by the process-notification scheduler

**Acceptance Criteria**
- [ ] Create index for sims.notifications table with dateSent and createdAt
- [ ] Check on the query on getPendingCOEs

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by locating the schema or migration for sims.notifications and the getPendingCOEs query used by the process-notification scheduler. Check how notifications are filtered by dateSent and createdAt, then verify that the requested index is present and that the query has been reviewed for the scheduler's once-per-minute retrieval.

Written by the indexing model from the issue text.

Assessment

Domain
databases
Issue type
Refactor
Difficulty
3/5
Estimated time
1-2 days
Activity status
Active
Clarity
Mostly clear
Newbie friendliness
65/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.