27
A correlated subquery per row got my D1 backfill killed at 12,000 rows: exceeded its CPU time limit and was reset
The backfill needed, for each comment, whether it was the top scoring one on its post and whether it was the first reply after a long gap. I wrote what reads naturally: a subquery per row. Twelve thousand rows in, D1…