optimize events creation and improve indexes

[sainak]

Proposed Changes

• optimize events creation and improve indexes
• closes https://github.com/ohcnetwork/care/issues/2369

Merge Checklist

• [ ] Tests added/fixed
• [ ] Update docs in /docs
• [ ] Linting Complete
• [ ] Any other necessary step

Only PR's with test cases included and passing lint and test pipelines will be reviewed

@ohcnetwork/care-backend-maintainers @ohcnetwork/care-backend-admins

[codecov[bot]]

Codecov Report

Attention: Patch coverage is 87.50000% with 1 line in your changes missing coverage. Please review.

Project coverage is 65.50%. Comparing base (12afd7a) to head (e71d158). Report is 52 commits behind head on develop.

Files with missing lines	Patch %	Lines
care/facility/events/handler.py	83.33%	1 Missing :warning:

Additional details and impacted files

@@             Coverage Diff             @@
##           develop    #2431      +/-   ##
===========================================
+ Coverage    65.38%   65.50%   +0.11%     
===========================================
  Files          242      243       +1     
  Lines        13976    14059      +83     
  Branches      1937     1950      +13     
===========================================
+ Hits          9138     9209      +71     
- Misses        4455     4464       +9     
- Partials       383      386       +3     

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

[sainak]

https://github.com/ohcnetwork/care/pull/2593