On 12/12/2018 11:52 PM, Dave Johnson wrote:
Thanks Cole... here is what I running... all CloudForms BZs that are open and not clones/docs/RFEs/trackers
session = RHBugzilla(url='https://bugzilla.redhat.com/xmlrpc.cgi')
kvps = {'f1': 'keywords', 'product': 'Red Hat CloudForms Management Engine', 'f3': 'short_desc', 'f4': 'component', 'f5': 'OP', 'classification': 'Red Hat', 'f7': 'short_desc', 'f8': 'CP', 'j5': 'OR', 'f2': 'short_desc', 'v1': 'FutureFeature', 'v2': 'RFE', 'v3': 'rfe', 'v4': 'Documentation', 'v6': 'tracker', 'v7': 'Tracker', 'f6': 'short_desc', 'query_format': 'advanced', 'bug_status': ['NEW', 'ASSIGNED', 'ON_DEV'], 'n4': '1', 'o7': 'notsubstring', 'o6': 'notsubstring', 'o4': 'substring', 'o3': 'notsubstring', 'o2': 'notsubstring', 'o1': 'notsubstring'}
session.query(kvps)
Looks like the slowness is due to this already reported bug:
https://bugzilla.redhat.com/show_bug.cgi?id=1658176
Add exclude_fields=["attachments"] to your query for now, it will speed things up greatly. Better still is to specify include_fields=[...] containing every field you are actually using in your script, so the query only pulls down exactly what your code is using
Thanks, Cole
python-bugzilla@lists.fedorahosted.org