Updated: Proposal for Abstraction Layer for Modifications in Bug.pm

[Christian Robottom Reis]

On Fri, Jul 09, 2004 at 05:51:04PM +0200, Matthias Juchem wrote:
>   * Bugzilla::Bug::get_* for reading the values of an bug
> 
>   * and maybe a few more that will come up during the following discussion or
>     during further design and implementation.

Hi Matthias,

    Just a note from my experience working on a time reporting feature
these last week. Getting data in order to process it efficiently may
preclude use of the Bug object in certain cases; this is admittedly a
performance hack, but it's the sort of hack that allows reports to be
generated in anything less than geological time.

    Just to serve as an illustration, one issue was that I needed to get
back a set of times and bug IDs that were dependent on a single bug. I
initially wanted to use bug objects, of course, and drill through its
methods, but instantiating a bug object for each of the thousands of
bugs I wanted was to be a major bottleneck, and I wrote the code to get
back a collection of IDs and descriptions using a small loop of queries,
and times for all of them using a single query.

Since we're talking about database independence and so on -- not wanting
to detract from your initiative, of course, since it is very relevant
because many of Bugzilla operations today are done on very small
collections of objects (at many times one or two) -- I thought it would
be something to put forward. Reporting and complex searching may require
separate interfaces if we want to be able to centralize the code while
keeping things sane in databases with tens of thousands of bugs.

Take care,
--
Christian Robottom Reis | http://async.com.br/~kiko/ | [+55 16] 3361 2331