Optimizing Azure SQL Database for Accessibility Reporting: WCAG Compliance Challenges
I've searched everywhere and can't find a clear answer. This might be a silly question, but Recently started working on a project that requires generating accessibility reports from data stored in an Azure SQL Database. The reports must meet WCAG compliance standards, ensuring that we’re not just compliant but also maintain optimal performance when querying large datasets. I've set up my database structure using Entity Framework Core 6, and I’m currently facing performance issues when executing complex LINQ queries. For instance, this query takes an unusually long time to return results: ```csharp var reports = await _context.AccessibilityReports .Where(r => r.ComplianceLevel == "A" && r.DateCreated >= startDate) .Include(r => r.User) .ToListAsync(); ``` It's fetching a lot of unnecessary data. I've tried adding indexes on the `ComplianceLevel` and `DateCreated` columns, but haven’t seen a significant improvement. During development, I also explored the possibility of using Azure SQL Database's built-in features like Query Performance Insights and the Database Advisor, but the recommendations seem overly simplistic and don’t align with our specific needs. Additionally, I’m trying to ensure the database structure supports accessibility-related metadata efficiently. This includes optimizing the way screen-reader data is stored and retrieved, which might influence our query designs. Has anyone had success with optimizing queries in Azure SQL for large datasets while keeping WCAG compliance in mind? Any advice on database indexing strategies or LINQ optimizations would be greatly appreciated. Also, if anyone has insights on how to structure data for better accessibility reporting, that would be a bonus! I'd really appreciate any guidance on this. What am I doing wrong?