MLH has enough snapshot rows that almost every page in InterviewStats interviews are sluggish;
- 30 seconds to load and view the snapshot rows for an interview (125k rows); surprised this even works, although the excel process doesn't work. The page itself is unusable because it's too much content for the browser to render.
- 17 seconds for the initial page to load. Fairly certain this because it's doing a count of the number of session for each interview on that loading screen, so it has to iterate over each interview individually. Could try to throw an index over the interview column of the snapshot table and see if that improves it at all.
MLH has enough snapshot rows that almost every page in InterviewStats interviews are sluggish;