care icon indicating copy to clipboard operation
care copied to clipboard

Fix N+1 queries in `/api/v1/getallfacilities/`

Open sainak opened this issue 1 year ago • 0 comments

Sentry Issue: CARE-M3 Sentry Issue: CARE-KX

Transaction Name /api/v1/getallfacilities/
Parent Span django.view - facility-list
Repeating Spans (0) db - SELECT COUNT(*) AS __count FROM facility_bed WHERE (facility_bed.deleted = %s AND facility_bed.facility_id = %s)
db - SELECT users_ward.id, users_ward.local_body_id, users_ward.name, users_ward.number FROM users_ward WHERE users_ward.id = %s
db - SELECT COUNT(*) AS __count FROM facility_patientregistration WHERE (facility_patientregistration.deleted = %s AND facility_patientregistration.facility_id = %s AND facility_patientregistration.is_active = %s)

Sentry Issue: CARE-M2

Transaction Name /api/v1/facility/
Parent Span django.view - facility-list
Repeating Spans (0) db - SELECT COUNT(*) AS __count FROM facility_patientregistration WHERE (facility_patientregistration.deleted = %s AND facility_patientregistration.facility_id = %s AND facility_patientregistration.is_active = %s)
db - SELECT COUNT(*) AS __count FROM facility_bed WHERE (facility_bed.deleted = %s AND facility_bed.facility_id = %s)

sainak avatar Jun 02 '23 11:06 sainak