Provide warning after returning large queries

Bug #1227830 reported by Nicholas Skaggs
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Autopilot
Fix Released
High
Unassigned
autopilot (Ubuntu)
Fix Released
Undecided
Unassigned
Saucy
Won't Fix
Undecided
Unassigned

Bug Description

Autopilot should provide a warning after returning a large number of objects for a select query.

Eg,

select_many('Label') will return a huge object set and take a long time. While it might be impossible to know the size of the query beforehand, a warning line to the output of the test can alert test authors to potentially poorly written or performing code.

As an addendum could similar warnings should exist for selects that time a long time to run, indicative of a similar performance issue?

Related branches

Changed in autopilot:
status: New → In Progress
importance: Undecided → High
assignee: nobody → Thomi Richards (thomir)
Revision history for this message
PS Jenkins bot (ps-jenkins) wrote :

Fix committed into lp:autopilot/1.3 at revision 342, scheduled for release in autopilot, milestone Unknown

Changed in autopilot:
status: In Progress → Fix Committed
Revision history for this message
PS Jenkins bot (ps-jenkins) wrote :

Fix committed into lp:autopilot at revision 342, scheduled for release in autopilot, milestone 1.4

Revision history for this message
Launchpad Janitor (janitor) wrote :

This bug was fixed in the package autopilot - 1.3.1+13.10.20131003.1-0ubuntu1

---------------
autopilot (1.3.1+13.10.20131003.1-0ubuntu1) saucy; urgency=low

  [ Thomi Richards ]
  * Fix attribute error in click package support.
  * Remove a spurious log message. (LP: #1227852)
  * Fix several functional tests.
  * Fix a missing test dependency, and add more logging when a process
    exits before we find the introspection interface. (LP: #1229034)
  * Add a warning when an autopilot query returns many items, and should
    probably be optimised. (LP: #1227830)

  [ Jamie Strandboge ]
  * Adds the apparmor rule needed for click package testing.

  [ Christopher Lee ]
  * Backout additions for logging when a process dies.
  * Changes how the proxy objects are created so the inheritance is
    correct. (LP: #1230046)
  * Fixes issue where a classes _Backend can be None causes uncaught
    exceptions. (LP: #1233972)

  [ Ubuntu daily release ]
  * Automatic snapshot from revision 343
 -- Ubuntu daily release <email address hidden> Thu, 03 Oct 2013 09:40:57 +0000

Changed in autopilot (Ubuntu):
status: New → Fix Released
Changed in autopilot:
milestone: none → 1.4
status: Fix Committed → Fix Released
Revision history for this message
Rolf Leggewie (r0lf) wrote :

saucy has seen the end of its life and is no longer receiving any updates. Marking the saucy task for this ticket as "Won't Fix".

Changed in autopilot (Ubuntu Saucy):
status: New → Won't Fix
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.