Our TestRail instance struggles whenever I run or view our custom reports—the ones that pull together test cases, test runs, and linked defects. I need someone who knows TestRail inside-out to pinpoint the performance bottlenecks and implement fixes so those reports open and refresh quickly, even as our database keeps growing. Here’s what I’m expecting: • A diagnosis of why the current custom reports drag (database indexes, query structure, server settings, or TestRail configuration). • Concrete optimizations applied and documented. • A before-and-after benchmark that proves the speed improvement and the steps to reproduce it in staging or future environments. You should already be comfortable working with TestRail’s schema, MySQL (or the database you find underneath), and have a pragmatic approach to profiling slow queries and tuning the application without breaking existing functionality. If that sounds familiar, let’s get started.