Database Optimization & Query Refactoring

[SudiptaPaul-31]

Issue: Database Optimization & Query Refactoring

Description
Optimize Prisma queries and improve overall database performance. Refactor redundant DB calls to ensure scalability for large datasets and maintain efficient query execution.

Acceptance Criteria

• Identify and refactor redundant Prisma queries
• Optimize query patterns for performance (joins, batching, caching)
• Add appropriate PostgreSQL indexes for frequently queried fields
• Ensure queries scale efficiently with large datasets
• Maintain consistent API response times under load
• Document optimization strategies for contributors

[Awointa]

@Awointa has applied to work on this issue as part of the Stellar Wave Program's 5th wave.

Hi, I’m interested in this issue. I have experience optimizing Prisma-based backends and improving database performance through query refactoring, indexing, and reducing redundant database calls.

I can refactor inefficient Prisma queries, introduce better query patterns (including batching and optimized joins), add appropriate PostgreSQL indexes for frequently accessed fields, and ensure the API remains performant under larger datasets. I’ll also document the optimization decisions so future contributors can maintain scalability.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Awointa to this issue.

[iyanumajekodunmi756]

@iyanumajekodunmi756 has applied to work on this issue as part of the Stellar Wave Program's 5th wave.

i would love to work on this issue and i shall deliver with qualitative feedback

ℹ️ Repo Maintainers: To accept this application, review their application or assign @iyanumajekodunmi756 to this issue.

[TochukwuJustice]

@TochukwuJustice has applied to work on this issue as part of the Stellar Wave Program's 5th wave.

Hi, I would like to contribute to this issue. I’m a smart contract and backend dev working mostly with Solidity, TypeScript, and secure EVM setups. My focus is always on writing clean, gas-optimized, production-ready code without adding unnecessary clutter. I'll dive straight into fixing just this specific issue, document everything clearly, and make sure not to touch or disrupt anyone else's work.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @TochukwuJustice to this issue.

[shadrach68]

@shadrach68 has applied to work on this issue as part of the Stellar Wave Program's 5th wave.

Hi, I am confident that I can resolve this issue as soon as possible if assigned to me because I have the technical expertise to resolve it.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @shadrach68 to this issue.