Bugzilla is very slow

[Gil Idelson]

Hi
I'm using Bugzilla 4.4.on WIN 7 32 bit using mysql database and apache server

Recently the new bug process became very very slow.
After I press "Submit bug" it can take 10+ seconds until I get the web page that says "email sent to..."

My questions are:

1. I think it database access time problem (we have around 1800 bugs) . Is Bugzilla 5 supposed to access faster to mysql database?

2. Can in install Bugzilla on on 64bit windows or on windows server ? Do you think it will work faster? 32bit windows can support more than 4GB of memory (actually 3GB) and 64bit windows can support mush more...

best regards ,
Gil Idelson

[Gil Idelson]

Of course I meant than win 32bit CANT support more than 4GB...

best regards ,
Gil Idelson

RT/Embedded SW Engineer
Microsemi Corporation - POE BU
1 Hanagar St. P.O.Box 7220
Hod Hasharon, 4501305, Israel
Phone: +972-9-7755100 Ext 271
Fax: +972-9-7755111

[Thorsten Schöning]

Guten Tag Gil Idelson,
am Mittwoch, 29. Juli 2015 um 11:51 schrieben Sie:

> Recently the new bug process became very very slow.

So ask you IT what has changed recently.

> After I press "Submit bug" it can take 10+ seconds until I get the
> web page that says "email sent to..."

You have some network related problems regarding the sending of mails,
have a look at DNS resolution or firewalls or proxys or such between
your Bugzilla and your mail server.

> 1. I think it database access time problem (we have around
> 1800 bugs) . Is Bugzilla 5 supposed to access faster to mysql database?

I think you are guessing wrong and 1800 bugs really is nothing, I
guess your smartphone could handle that in a CSV file easily. ;-) The
amount of bugs doesn't say anything, what you need to have a look at
is concurrent user access and such, if you use mod_perl or not,
because spawning Perl/CGI processes in Windows is somewhat slow at all
etc.

> 2. Can in install Bugzilla on on 64bit windows or on windows
> server ?

Of course, but surely won't change anything.

> Do you think it will work faster?

No.

> 32bit windows can
> support more than 4GB of memory (actually 3GB) and 64bit windows can support mush more...

So did you have a look at least at your task manager for the spawned
Perl/CGI process if they even consume this many RAM? Hint: They wont. ;-)
Where should the used GB of RAM come from? I guess your entire
database is not that large, so do you think Perl/CGI/Bugzilla
generates random data just to exhaust 32 Bit process memory limits?
Hint again: It doesn't. ;-)

Look at your mail settings and network, that's most likely your issue.

Mit freundlichen Grüßen,

Thorsten Schöning

--
Thorsten Schöning E-Mail: Thorsten....@AM-SoFT.de
AM-SoFT IT-Systeme http://www.AM-SoFT.de/

Telefon...........05151- 9468- 55
Fax...............05151- 9468- 88
Mobil..............0178-8 9468- 04

AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln
AG Hannover HRB 207 694 - Geschäftsführer: Andreas Muchow

[Gervase Markham]

On 29/07/15 10:51, Gil Idelson wrote:
> Recently the new bug process became very very slow. After I press
> "Submit bug" it can take 10+ seconds until I get the web page that
> says "email sent to..."

As Thorsten says, this is likely to be a mail issue. Turn off email and
see if it speeds up. If it does, that's your problem.

Gerv