Custom fields schema

[Kevin Benton]

> (1) We've found that for excessively complex queries, generating them
> in cron and dumping them as HTML is useful. That is just the
> unfortunate reality at times.

For the queries I'm doing, it isn't acceptable to Cron the queries.  And if
I'm taking 60 seconds to run a query at ~3K records, how will that scale
when it's 100K+ records?  1M+ records?

---
Kevin Benton
Perl/Bugzilla Developer
Advanced Micro Devices
 
The opinions stated in this communication do not necessarily reflect the
view of Advanced Micro Devices and have not been reviewed by management.
This communication may contain sensitive and/or confidential and/or
proprietary information.  Distribution of such information is strictly
prohibited without prior consent of Advanced Micro Devices.  This
communication is for the intended recipient(s) only.  If you have received
this communication in error, please notify the sender, then destroy any
remaining copies of this communication.
 
 

> -----Original Message-----
> From: developers-owner at bugzilla.org [mailto:developers-owner at bugzilla.org]
> On Behalf Of Luis Villa
> Sent: Friday, January 28, 2005 11:21 AM
> To: developers at bugzilla.org
> Subject: Re: Custom fields schema
> 
> On Fri, 28 Jan 2005 11:08:21 -0700, Kevin Benton <kevin.benton at amd.com>
> wrote:
> > I am writing statuscount.cgi - a completely new reporting package for
> > Bugzilla to show my management the information they need out of Bugzilla
> to
> > help them effectively direct development.  I expect this report will be
> run
> > about one to five times a week.  This report currently executes eight
> > distinct queries of which six are complex.  So, if the queries are
> running
> > an average of 50+ seconds each first-time, it's going to take on the
> order
> > of five to six minutes for the manager to get the information they're
> > looking for.  That will prevent my managers from using my reports.  On
> the
> > other hand, if my report takes less than ten seconds, I will be doing
> okay.
> > When I'm reasonably close to being done with this reporting software, I
> will
> > release it to the Bugzilla community.  I've already got at least two
> non-AMD
> > testers evaluating it for me now.
> 
> (1) We've found that for excessively complex queries, generating them
> in cron and dumping them as HTML is useful. That is just the
> unfortunate reality at times.
> 
> (2) GNOME would love to help you evaluate it as well :)
> 
> Luis
> -
> To view or change your list settings, click here:
> <http://bugzilla.org/cgi-bin/mj_wwwusr?user=kevin.benton@amd.com>