Today I took on the challenge of improving the performance of a set of repository retrieval methods that have been a bottleneck for our system for the past week. Here were the requirements and details for the most challenging method: There is a Clinic and a Service table with a joining table for the many-to-many relationship, ClinicService. A clinic provides one to many services and a service can be provided by one to many clinics. The method accepts in a list of primary key integer values for the...