Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Issue 4: Performance Improvement - Optimize Database Queries #11

Closed
rajuljha opened this issue Mar 16, 2025 · 2 comments
Closed

Issue 4: Performance Improvement - Optimize Database Queries #11

rajuljha opened this issue Mar 16, 2025 · 2 comments

Comments

@rajuljha
Copy link
Owner

rajuljha commented Mar 16, 2025 •
edited
Loading

Description:
Some API endpoints take too long to respond due to inefficient database queries.

Affected Endpoints:

  • /eduai

Suggested Fix:

  • Use indexing for frequently queried columns.
  • Optimize SQL queries to reduce execution time.

Expected Performance Gain:

  • Reduce response time from 2s to <500ms.

Labels: performance, backend
@rajuljha
Copy link
Owner Author

Solution found: Use db_index=True in the django models at https://github.com/rajuljha/iitr-byte_club/blob/main/BrainByte/eduai/models.py

@rajuljha
Copy link
Owner Author

Marking this as closed as #4 fixes it.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@rajuljha