85 hours spent updating 234 rows in the database
An unexpected query in the database spent 85 hours updating 234 rows. Important lessons on performance improvements were drawn.
It was discovered that a query unexpectedly consumed database resources while updating a 24 million row table. Despite returning a 200 response code, it had to perform a full scan of the table with each call. In total, it resulted in 85 hours of execution time for only 234 rows changed.