Lighthouse has a new layout. Prefer the old one? Return to the old layout, and switch back any time from the link at the top of each page.

Figure out why student upload took almost 5 minutes

#551

1800 students in production, I bet it is a locking issue, but it could be an indexing problem as well.

Reported by shawn (at vegantech) · January 7th, 2011 @ 12:27 PM

State: resolved
Assigned to: shawn (at vegantech) shawn (at vegantech)

Activity

  1. shawn (at vegantech)
    shawn (at vegantech)
    • State changed from new to resolved

    (from [b4619d105feb6e16a1e0fe98c3d15be0d49aa21f]) [#551 state:resolved] split claiming students into 2 queries and adjusted indexes on tables to improve performance of both. https://github.com/vegantech/sims/commit/b4619d105feb6e16a1e0fe98c3...

    January 8th, 2011 @ 07:42 PM

  2. shawn (at vegantech)
  3. shawn (at vegantech)
    shawn (at vegantech)
    • Milestone changed from Demo Site and Export Doc/Feedback to For Jan 2011 DPI meeting
    • Milestone order changed from 82 to 0

    January 9th, 2011 @ 04:25 PM

  4. shawn (at vegantech)
    shawn (at vegantech)
    • Milestone order changed from 1 to 0

    it was an indexing issue on the query that claims students without state id's. This change also reduced MMSD's import time from 64 to 12 minutes!

    January 9th, 2011 @ 05:00 PM

  5. shawn (at vegantech)
    shawn (at vegantech)
    • Milestone changed from For Jan 2011 DPI meeting to For Apr 2011 DPI Meeting
    • Milestone order changed from 4 to 0

    March 28th, 2011 @ 03:40 PM

  6. shawn (at vegantech)
    shawn (at vegantech)
    • Milestone changed from For Apr 2011 DPI Meeting to For Jan 2011 DPI meeting
    • Milestone order changed from 20 to 0

    March 28th, 2011 @ 03:42 PM

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.