On Fri, Sep 26, 2008 at 01:10:52PM +0200, Lucas Nussbaum wrote: > > (2) the way we deal with bugs affecting two (or more) packages. > That's a tricky problem. On one hand, the correct way to solve that > would be to have a separate "affected_packages" table, with (id, > package) columns, and also an "affected_sources" table. > > On the other hand, that's makes all queries more complex, because you > have to join this additional table (and it's not going to be a small > table). Currently, there are only 78 unarchived bugs (out of 69982) > which are affected to 2 or more packages (select count(*) from bugs > where package like '%,%'). > > One possibility would be to keep the package/source columns in bugs, but > add tables with (id, package) and (id, source). That way, people not > interested in this case can join the additional table, while others can > just ignore it. It would only increase a bit the time needed to import > the bugs (about half an hour currently, only I/O bound).
I was thinking about adding the bug two times in the bugs table. Kurt -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
