Patient Records Query Performance Improvements-created-by-agentic

[shaykeren]

This issue tracks performance improvements for the Patient Records Query endpoint.

Current Changes:

1. Added index on patient_weight column
2. Implemented batch processing in getRecords method
3. Added result caching
4. Optimized query execution

Future Improvements:

1. Review and potentially revert load testing features from PR Feature/rds load #45
2. Consider separating load testing operations to a different database instance
3. Implement data archiving strategy for table growth management

Related PR: #79

Please review and provide feedback on the proposed changes.