Red Hat Bugzilla – Bug 823328
query with query_format='advanced' column_list=['bug_id'] much much slower after upgrade to bugzilla 4
Last modified: 2013-01-10 01:47:17 EST
Previously when doing bugzilla queries we could pass a minimal column_list parameter which was a big speed boost.
Using the python-bugzilla library, I was previously doing
# 'query_format' only needed with rhbugzilla4
Would complete in 3-5 seconds. Now it's taking over a minute.
Here's a comment from /usr/bin/bugzilla about why it's a useful optimization, if it's any help:
#to optimize speed and reduce network traffic through lookups, we
#specifically tell bugzilla the exact data we want. This allows us
#make one call to output the data, rather than have a follow-on
#getbug() to grab more info than what the default has.
#Testing has shown this to be a _huge_ time saver. Unfortunately,
#this list and the output format have to be in _sync_. Otherwise,
#you lose speed by doing a look-up for each new output element.
In addition to the parameters below, this method also accepts the standard include_fields, exclude_fields and extra_fields arguments
so if you specified
include_fields => ['id']
You would get just the bug id. (the field is known as 'id' in Bug.search / Bug.get now.
Okay, if column_list isn't effective anymore, python-bugzilla probably needs to be changed, so reassigning.
This has been fixed for awhile