Query-Logs Endpoint Performance Optimization-created-by-agentic

[doppleware]

Performance issues have been identified with the /query-logs endpoint showing severe degradation. The following optimizations have been implemented:

1. Added btree index on numeric_value column:

CREATE INDEX crystaldba_idx_clinic_activity_logs_numeric_value_1 ON clinic_activity_logs USING btree (numeric_value);

2. Optimized query to select only needed columns instead of all columns
3. Implemented query result caching using Spring's @Cacheable
4. Added pagination support to limit response size
5. Improved query parameterization

A pull request (#450) has been created with these changes.

Additional recommendations for ongoing maintenance:

1. Monitor the index usage and performance
2. Review and tune cache settings based on usage patterns
3. Consider implementing request rate limiting if needed
4. Set up regular database maintenance procedures

Please review and merge the PR to resolve the performance issues.