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.

csv upload performance

#611

for example student groups
add mapped columns that are indexed integers and only do the expensive join once.

insert into groups_students

  (student_id,group_id)
  select u.id , g.id from student_groups_1001893421_importer tug inner join
  students u use index district_id on u.district_student_id = tug.district_student_id
  inner join groups g
  on tug.district_group_id = g.district_group_id
  and u.district_id = 1001893421
  where not exists (
  select 1 from groups_students gs
    where gs.group_id = g.id and gs.student_id = u.id)
  group by u.id,g.id

Reported by shawn (at vegantech) · March 14th, 2011 @ 06:28 AM

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

Activity

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

    March 28th, 2011 @ 03:40 PM

  3. shawn (at vegantech)
    shawn (at vegantech)
    • Milestone changed from For Apr 2011 DPI Meeting to Evaluate to see if applicable.
    • Milestone order changed from 73 to 0

    November 9th, 2012 @ 07:26 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.