Skip to content
  • Stevan Radakovic's avatar
    all_devices() api call to do one big query instead of many small ones. · 3e8dbfec
    Stevan Radakovic authored
    device.is_visible_to was called for all devices which generated
    approx. num_of_devices * num_of_devices_of_specific_device_type
    queries before filtering out the RETIRED devices.
    Currently on production that's approx. 100,000 queries per
    all_devices api call.
    This patch also reduces the number of queries to the device_type
    and test_job table for each device.
    
    Change-Id: I9e1b54a088ae6173f337a0e4690484d952d57df7
    3e8dbfec