N+1 Query Performance Issue in Vets Endpoint-created-by-agentic

[shaykeren]

Issue Description

The /vets.html endpoint is experiencing an N+1 query performance issue when loading veterinarians and their specialties. This is caused by:

1. Eager loading of the specialties collection in the Vet entity
2. Lack of join fetch optimization in the repository queries

Impact

• Multiple unnecessary database queries are executed for each vet's specialties
• Reduced performance when listing vets, especially with larger datasets
• Potential scalability issues

Solution

A fix has been implemented in PR #94 with the following changes:

1. Changed specialties relationship to lazy loading with batch size optimization
2. Added optimized repository methods using join fetch
3. Updated existing methods to use the optimized queries

Validation

The changes have been tested to ensure:

• Functionality remains the same
• Query performance is improved
• Pagination works correctly
• Caching is preserved

Related PR: #94