[Bug 19331] New: Updating bugs with lots of CCs take far too long

http://bugs.winehq.org/show_bug.cgi?id=19331

Summary: Updating bugs with lots of CCs take far too long
           Product: WineHQ Bugzilla
           Version: 3.2.3
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Keywords: source
          Severity: trivial
          Priority: P4
         Component: bugzilla-unknown
        AssignedTo: [e-mail]
        ReportedBy: [e-mail]

I'm sure anyone who has been using Bugzilla for long enough has noticed that
updating bugs with a large number of CCs and/or votes takes unreasonably long.
Marking a bug a duplicate of another can time out.

You can ignore this by reopening the bug without waiting for the page to
reload, and the emails will still be sent.

Can something be changed for this?  We don't really need to know who is being
emailed, it can be assumed from the lists.

[Bug 19331] Updating bugs with lots of CCs take far too long

http://bugs.winehq.org/show_bug.cgi?id=19331

Jeremy Newman  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |ASSIGNED
         AssignedTo|[e-mail]        |[e-mail]

--- Comment #1 from Jeremy Newman   2009-09-22 12:58:38 ---
I've been taking a look into this. We added more RAM to the webserver. I
increased the mySQL innodb_buffer_pool_size to 8G. I'm hoping this will speed
things up a bit.

[Bug 19331] Updating bugs with lots of CCs take far too long

http://bugs.winehq.org/show_bug.cgi?id=19331

--- Comment #2 from Jeremy Newman   2009-09-22 13:10:01 ---
I think I've done as much as I can on the DB side. I am now checking the e-mail
sending side.

I've changed the bugzilla setting mail_delivery_method to "Sendmail" and set
the option sendmailnow to "Off". This should use sendmails feature of queue and
send so we are not waiting on a successful send of each email. This should
speed things up a bit.

[Bug 19331] Updating bugs with lots of CCs take far too long

http://bugs.winehq.org/show_bug.cgi?id=19331

--- Comment #3 from Alexandre Julliard   2009-09-22 13:30:41 ---
Testing update speed, ignore.

[Bug 19331] Updating bugs with lots of CCs take far too long

http://bugs.winehq.org/show_bug.cgi?id=19331

--- Comment #4 from Nikolay Sivov   2009-09-27 12:00:08 ---
It's much faster now and doesn't depend on CC list length, visually I mean.
Maybe this is fixed.

[Bug 19331] Updating bugs with lots of CCs take far too long

http://bugs.winehq.org/show_bug.cgi?id=19331

Ken Sharp  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|ASSIGNED                    |RESOLVED
         Resolution|                            |FIXED

--- Comment #5 from Ken Sharp   2009-09-30 11:40:25 ---
Definitely much faster, a very nice improvement.

[Bug 19331] Updating bugs with lots of CCs take far too long

http://bugs.winehq.org/show_bug.cgi?id=19331

Ken Sharp  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |CLOSED

--- Comment #6 from Ken Sharp   2009-09-30 11:40:34 ---
Closing.