Release Notes

The Gradebook page is now more resilient and significantly faster when loading assignment statistics.

When you open the Gradebook tab for a subject, NavEd calculates the highest, lowest, and average grade for each assignment. Previously, each of those calculations was triggering dozens of unnecessary individual database lookups — one for every student result, just to check a setting on the subject. For a class with 10 assignments and 20 students, that could mean over 600 tiny database calls on a single page load.

We've optimized all three grade statistic methods to load the data they need in a single efficient query per assignment. This dramatically reduces the number of database calls, makes the page load faster, and eliminates a rare crash that could occur if the database connection was briefly interrupted during the long chain of lookups.

Fixes and Improvements¶

• Gradebook: eliminated repeated per-assignment database lookups in highest/lowest/average grade calculations
• Gradebook: pre-loads subject data to avoid redundant lookups per assignment
• Applies to both the Subject Overview and standalone Grades views

Removed a diagnostic check that was generating occasional background errors.

A debug session-verification query in our middleware was occasionally failing due to database connection timing during high-traffic moments. The query was leftover diagnostic code from a resolved session persistence investigation and served no functional purpose — sessions have been saving correctly all along.

We've removed the unnecessary verification step, which eliminates the background error and shaves one redundant database query off every page load.

Fixes and Improvements¶

• Removed stale session-persistence diagnostic query from background middleware
• One fewer database query per page load in production

Improved error filtering for transient infrastructure disruptions during page loads.

When our hosting provider's database proxy briefly disconnects during infrastructure maintenance, some page loads were generating error reports that our monitoring couldn't recognize. We've extended our error filter to detect those wrapped errors properly, and improved how grade calculation methods report errors internally for faster diagnosis.

Fixes and Improvements¶

• Extended error filter to catch infrastructure disruption errors even when wrapped by application-level handling
• Improved error handling in grade calculation methods to preserve error context for faster debugging

Reduced background noise in error monitoring from transient infrastructure events.

Occasionally, our hosting provider's database proxy goes through brief unavailability windows during infrastructure maintenance. Our background task worker was dutifully reporting these connection timeouts to our error tracker, even though it automatically recovers within seconds every time. These transient errors were creating noise that made it harder to spot real issues.

We've added a targeted filter that recognizes these connectivity errors and suppresses them from our error feed, while continuing to surface any genuine database errors. The background worker's self-healing behavior is unchanged — tasks continue to be retried and caught up automatically.

Fixes and Improvements¶

• Added error filter for transient infrastructure connectivity errors

Google sign-in is now faster for new users.

When a new user signed in with Google for the first time, NavEd was searching every school twice — once looking for an existing account, and again looking for a pending invitation. With 30+ schools on the platform, this added ~300ms of unnecessary delay to the sign-in flow.

Now both checks happen in a single pass through the schools, cutting the lookup time roughly in half.

Fixes and Improvements¶

• Consolidated two separate school-scanning loops into one during Google sign-in