Intelligent Diabetic Retinopathy Scan (IDRS)

• Use temporary tables to keep the intermediate result set

• SELECT COUNT FROM dctc.patient_registration pr
• LEFT OUTER JOIN dctc.patient_fundus_imges_api pat_api ON pr.glob_patient_reg_id = pat_api.glob_patient_reg_id
• LEFT OUTER JOIN dctc.mas_institution mi ON mi.hospital_id = pat_api.inst_id
• LEFT OUTER JOIN dctc.pat_fun_grad_man gm ON pat_api.fundus_images_id = gm.fundus_images_id
• LEFT OUTER JOIN dctc.pat_fun_grad_ai gai ON pat_api.fundus_images_id = gai.fundus_images_id
• WHERE pr.is_valid = 'Y' AND pat_api.is_valid = 'Y'
• Keep the result from the above in a temporary table and refer temporary table in all other queries.

• DR for the time being can be commented on.

• Create an index with fields (fundus_images_id, grade) in tables pat_fun_grad_man and pat_fun_grad_ai

• Instead of converting each time in query run, store from_date_str::timestamp value as a variable in the function start itself

• AND pat_api.capture_date_time >= from_date_str::timestamp
• AND pat_api.capture_date_time <= to_date_str::timestamp;