TFRS - Slow loading performance in Production

[justin-lepitzki]

Describe the task: The TFRS Production environment is experiencing a noticeable slowdown, specifically when accessing the Compliance Report Details View. While we had previously enhanced performance, a regression seems to have occurred. The objective of this card is to pinpoint the root cause of the slowdown, primarily focusing on the Django database queries and API calls. Once identified, implement the necessary optimizations to enhance load speed.

Purpose: Ensure that the TFRS system functions at an optimum pace, especially the Compliance Report Details View. Slow loading times have been affecting user experience and overall productivity. Concentrate improvements on the main branch.

Acceptance Criteria:

• [ ] Identify and document which Django database queries are causing the slowdown in the Compliance Report Details View.
• [ ] Determine which API calls, during the details view loading, are performance bottlenecks.
• [ ] Implement performance enhancements to resolve identified issues and validate that the Compliance Report Details View loads within acceptable timeframes.

Additional context: When the performance upgrades were implemented a few months ago, the loading times were deemed satisfactory. However, the recent slowdown suggests that there may be new factors or overlooked elements contributing to the current performance lag. A thorough investigation will not only optimize the current state but will also provide insights to prevent similar issues in the future.