WIP: Grad Report Download Quicker

psu-libraries / etda_workflow

Electronic Theses and Dissertations Application: Admin, Author, and Committee Member workflows.

MIT License

3 stars 1 forks source link

WIP: Grad Report Download Quicker #835

Open ajkiessl opened 2 months ago

ajkiessl commented 2 months ago

Something's not right here. It's not returning nearly as many records as the other way

ajkiessl commented 2 months ago

The original outputs ~28000 records. This outputs ~8000 records. Not totally sure why but it does look like maybe the old one is outputting duplicates.

ajkiessl commented 2 months ago

I might actually be looking at the wrong output for the first one, so not sure.

ajkiessl commented 2 months ago

Might have something to do with me changing the the LEFT joins to INNER joins 😆

ajkiessl commented 2 months ago

That didn't work. Still too slow