Figure out why student upload took almost 5 minutes
Reported by shawn (at vegantech) | January 7th, 2011 @ 12:27 PM | in For Jan 2011 DPI meeting
1800 students in production, I bet it is a locking issue, but it could be an indexing problem as well.
Comments and changes to this ticket
-
shawn (at vegantech) January 8th, 2011 @ 07:42 PM
- 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...
-
shawn (at vegantech) January 8th, 2011 @ 07:42 PM
(from [30fca2e58783a99289120f753db5f516728a5a9a]) [#551] new index for students in schema.rb https://github.com/vegantech/sims/commit/30fca2e58783a99289120f753d...
-
shawn (at vegantech) January 9th, 2011 @ 04:25 PM
- Milestone changed from “Demo Site and Export Doc/Feedback” to “For Jan 2011 DPI meeting”
- Milestone order changed from “82” to “0”
-
shawn (at vegantech) January 9th, 2011 @ 05:00 PM
- 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!
-
shawn (at vegantech) March 28th, 2011 @ 03:40 PM
- Milestone changed from “For Jan 2011 DPI meeting” to “For Apr 2011 DPI Meeting”
- Milestone order changed from “4” to “0”
-
shawn (at vegantech) March 28th, 2011 @ 03:42 PM
- Milestone changed from “For Apr 2011 DPI Meeting” to “For Jan 2011 DPI meeting”
- Milestone order changed from “20” to “0”
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.
Create new ticket
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป
Student Intervention Monitoring System
People watching this ticket
shawn (at vegantech)
Referenced by
-
551
Figure out why student upload took almost 5 minutes
(from [b4619d105feb6e16a1e0fe98c3d15be0d49aa21f])
[#551
s...
-
551
Figure out why student upload took almost 5 minutes
(from [30fca2e58783a99289120f753db5f516728a5a9a])
[#551] ...