FogBugz Technical Support

A forum for technical support discussion related to Fogbugz.
The current FogBugz Knowledge Base can be found at http://help.fogcreek.com/fogbugz.

Posts by Fog Creek Employees are marked:

Documentation
Release Notes
Network Status

4.0 Slooooow??

SO we upgraded to 4.0 today and, boy, is it a lot slower.  Things take drumb-your-fingers time to complete in many cases... like, just seeing a list of cases.  This use to be lightning fast.

What gives?

David
David Whatley Send private email
Thursday, March 3, 2005
 
 
Something isn't configured correctly then...

What db are you using?  Is it on another machine?
Michael H. Pryor Send private email
Thursday, March 3, 2005
 
 
I'm not sure if this is related.... but some bugs now all have stuff like:

See also: 30680, 30678, 30677, 30676, 30674, 30673, 30672, 30671, 30670, 30669, 30668, 30667, 30666, 30665, 30664, 30663, 30662, 30661, 30660, 30659, 30658, 30657, 30656, 30655, 30654, 30653, 30652, 30651, 30650, 30649, 30647, 30643, 30641, 30640, 30639, 30638, 30637, 30636, 30635, 30634, 30633, 30631, 30630, 30629, 30626, 30625, 30623, 30622, 30619, 30617, 30616, 30615, 30614, 30612, 30611, 30610, 30609, 30608, 30605, 30604, ... List All

We have a certain class of bugs that are submitted by an automated system, and I guess that groups them all as user.  There are LOTS of those and, conjecturing here, but I think it's taking a lot of time to produce this huge cross-reference list.

Does that seem like it might be the problem?
David Whatley Send private email
Thursday, March 3, 2005
 
 
There's an index on that field, so no, I don't think that's it (we have the same setup here).

What database are you using?
Michael H. Pryor Send private email
Thursday, March 3, 2005
 
 
I'll have to check on the config.  We're using ODBC to something, but I'll have to check with our sysadmin to see what's on the other end.

-- David
David Whatley Send private email
Thursday, March 3, 2005
 
 
We are having a similar problem.

Here's our environment... FogBugz is on a Win 2003 box and we have our Sql Server on a different Win 2003 machine. We are a HIGH volume internal IT/MIS shop. We have almost 13,000 total cases. FogBugz is fed by 7 mailboxes, often containing fairly large attachments. Our database is over 10GB now. This is all from our install starting in June 2004 (roughly 9 months).

Most cases take 2 to 10 seconds to pull up. Most of the list views, every with many cases seems to pull up in < 2 sec.

It's odd though. One case which has about 6 bug events (4 emails with only a few sentences) takes consistently 7 to 9 seconds to come up every time. I have our DBA looking into it, and he thinks it may be the way Full-Text indexing is being used.

On a bright note, the new FogbugzMaint.exe has dramicatically improved email handling over dispatcho.exe.
Ryan Wood Send private email
Friday, March 4, 2005
 
 
List views are fast and looking at individual cases is slow... Weird.  You're using the straight 4.0.11 install right?

Is your connection string using Integrated Authentication?  Do you have any antivirus software installed on the FogBugz server?
Michael H. Pryor Send private email
Friday, March 4, 2005
 
 
Here's what I know...

We're using MySQL running on Linux, on another machine than the web server.

We connect via ODBC, username/password but not integrated authentication.

There is no antivirus running.

It is important to note that this is the exact same rig that ran the 3.0 version of FogBugz and that was blazingly fast at all times.

-- David
David Whatley Send private email
Friday, March 4, 2005
 
 

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
 
Powered by FogBugz Bug Tracking and Evidence-Based Scheduling.