FogBugz Technical Support

A forum for technical support discussion related to Fogbugz.
The current FogBugz Knowledge Base can be found at

Posts by Fog Creek Employees are marked:

Release Notes
Network Status

How big is your database?

Server server in the rack,
how many cases do you pack?

My production FogBugz database holds:
Max Case number: 1575
Actual Cases: 356 (Yes, I get lots of SPAM)
Max BugEvent id: 7138
Actual BugEvents: 2334
Approx size of db: 5.6Mb

As you can see my working db is rather small.

I'd like to create a volume database for testing CaseDetective, but was wondering just how many Cases I should create? 50k, 100k, 500k, 1 million?

How many Cases do you have in your FogBugz databases?
Ian M. Jones Send private email
Tuesday, December 13, 2005
Max Case Number: 257605
DB Size: 5 GB
Michael H. Pryor Send private email
Tuesday, December 13, 2005
Ugh, that's going to take some work to reproduce! Thanks Michael.

So, what about everyone else, what kind of size is your FogBugz database?
Ian M. Jones Send private email
Tuesday, December 13, 2005
Max case 4820
DB size 1.9Gb (Access!)
Paul W Morton Send private email
Wednesday, December 14, 2005
Ooh! What's the file size limit of the OS on your Fogbugz server?
Thomas Stache Send private email
Thursday, December 15, 2005
55275 Cases
7.8 GB DB (all our customer support voice mails and incoming faxes go into fb)
Jon M Send private email
Thursday, December 15, 2005
It seems I may need to re-think the implications of a feature I've always wanted to add to CaseDetective.

I've always thought it would great to have a local CaseDetective database synchronized with the FogBugz database. This would allow for fast local searches and other goodies, including off-line reporting.

This database would only include cases that the user has "permission" to see, but for an admin or similar user this equates to the entire database. And from the sound of things there could be some rather large FogBugz databases out there. This is the prime reason I didn't do this from the start, I have always been worried about the volume of Cases that would need to be held locally.

I may be worried for nothing, seeing as some people already have large volumes of data on their desktop machines. I for example already have over 40Gb of music in iTunes, and 6Gb of photos in iPhoto.

If anyone has any comments pro or con the concept of having a synchronized copy of the FogBugz database on their desktop machine, I'd love to hear from you either by commenting here or through email.
Ian M. Jones Send private email
Friday, December 16, 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.