Repository navigation
Kaapi: V1.0: Database optimization for performance issues #808
Description
Is your feature request related to a problem?
The database for v1.0 may not be optimized for performance and consistency. This could lead to inefficiencies and complications as we scale.
Describe the solution you'd like
- Audit indexes: add missing ones and remove unused
- Standardize on ID vs UUID usage across tables
- Standardize the timezone followed
- Log slow queries
- Adding ENUMS
Metadata
Metadata
Assignees
Labels
No labels
Type
Projects
- Status
Activity
[-]Kaapi v1.0: Database Review[/-][+]Database: Optimize for performance issues[/+][-]Database: Optimize for performance issues[/-][+]Kaapi: V1.0: Database optimization for performance issues[/+]AkhileshNegi commentedon May 16, 2026
Audit indexes: add missing ones and remove unused
This is done. We also added partial indexes where they made sense
Standardize on ID vs UUID usage across tables
We discussed this and agreed on a simple rule: use UUIDs for anything user-facing, and keep IDs for internal-only use.