CSV export timeout on full domain meta data

[abroddrick]

Current Behavior

Once again, the full domain meta data export on the analytics page is timing out and prevents us from getting the report

Expected Behavior

Full domain meta data (and other reports) don't time out.

Steps to Reproduce

1.go to stable

2. click /admin/analytics
3. click to full domain meta data download
4. see the timeout

AC

• [ ] this button no longer times out on stable
• [ ] the solution is tested on litterbox
• [ ] the csv export is refactored as needed to speed up processing (see additional context)
• [ ] modify the csv export code as needed to increase readability and ease of making additions in the future

Environment

stable

Additional Context

We will be expanding this feature to appear on the domains page for any user to pull down info for their domains, thus having this code more efficient would be good before we expand on it further.

Some things that have been discussed regarding the export:

• We have talked about storing the max domain managers in our system as a way to help increase processing time (if we know there are a max of 15 domain managers, we can know to make 15 domain manager columns and don't need to compute it again).
• We have also mentioned that the way queries are being done may be what is slowing it down and we should look at each query and all the columns they get and modify them to increase the processing speed
• Lastly, we discussed making the export buttons on the analyst page async using ajax/axios etc so that the timeout is never an issue (besides annoying the users with having to wait

All of the above should be considered on the table for this ticket at the discretion of the developer.

Issue Links

No response

[PaulKuykendall]

Looks good to pull in, per our slack thread