5 days to 30 seconds? What kind of factor/order of magnitude is that damn

What takes 5 days to run

Poorly made analytics/datawarehouse stuff.

One query per column per row