Bug 802641

The loop that deletes the entries from distro_map_controller and appends the activities is too slow.

bkr.server.labcontrollers:329 calls 
  distro.distro.activity.append(DistroActivity(etc etc))

Just the 'distro.distro.activity' makes the two following calls for each
distro entry that is to be deleted from the distro_lab_controller_map.


"SELECT distro.id AS distro_id, distro.install_name AS distro_install_name, distro.name AS distro_name, distro.breed_id AS distro_breed_id, distro.osversion_id AS distro_osversion_id, distro.arch_id AS distro_arch_id, distro.variant AS distro_variant, distro.virt AS distro_virt, distro.date_created AS distro_date_created 
FROM distro 
WHERE distro.id = %s"


"SELECT activity.id AS activity_id, distro_activity.id AS distro_activity_id, activity.user_id AS activity_user_id, activity.created AS activity_created, activity.type AS activity_type, activity.field_name AS activity_field_name, activity.service AS activity_service, activity.action AS activity_action, activity.old_value AS activity_old_value, activity.new_value AS activity_new_value, distro_activity.distro_id AS distro_activity_distro_id 
FROM activity INNER JOIN distro_activity ON activity.id = distro_activity.id 
WHERE %s = distro_activity.distro_id ORDER BY activity.created DESC, activity.id DESC"

Neither of these calls are needed.